I have a field needing primary key status. Within the field, there are
currently about 600 records with unique values. The remainder have been
allocated: UNASSIGNE-000_000000/001
The input mask is as follows: LLLLLLLLL\-999\_999990/999;0;-

I have a list box that I need to pick anywhere from one to twelve items out
of at any given time (fical periods actually).  With the data selected from
this box I need to run a query that filters on the items chosen.  I already
have the code that populates a text field called ...

I have a simple database for packs of timber.
These packs  have there own number and size and have many different lengths
from .900m thru to 7.2m in .300mm increments.
The table I created has a seperate coloum for each length and each pack may

Sorry I'm new to using VBA in Access.
I have a form the user enter data in, then my codes calculates variables
that I want to pass to a query. I.e. the user enters a date, say 4/15/07, and
I would like to tell a query to pull all date values between 4/1/07 and

May I know how to perform calculations from different table?
ItemTable - Bil(primarykey),ItemNumber,Quantity
MainItemTable - ItemNumber(primary key)
Loan-LoanID(primary key)

Hello, I know how to use SendObject to attach a file to my email, but is
there a way to display the results within the body of an email (not an
attachment). Thanks so much!!

I have a linked table that has yesterdays data in it
I have a nother linked table that has todays data in it
I would like to run a query that showed me only the added items
Thank You in advance

I created a select query to pull the records from a table. The query pull all
of the fields, including an autonumber field. When I run the select query,
all of the fields and records are returns.
I then created a parameter for this query. The parameter was in the Taxpayer

I have a similar problem to the discussion string below.
My MS Access table is from an XLS and is in the following format:
Field1        Field2           Field3           Field4
--------         ---------          ----------          ----------

Hi Ng
I got a table containing headers for quotations, with the columns QuoteDate,
QuoteNo, TrackNo, TotalQuoteAmount and other data about the customer.
I want to get the total value quoted for all customers for a given period of

I want to combine the following so that I have one total for hours worked
under each cost code. Example; date-4/17/07, cost code 003 311301, 16 hours
and on 4/19, 003 311301, 7 hours, how do I combine each repeated cost code
for a grand total of hours. I am using Access 2003.

I apologize ahead of time if this message is a repeat of any prior
messages...but it seemed like none of my posts were being posted.
I want to apologize ahead of time for being a novice with MS Access
and VBA.  I desperately need help with 2 queries that I am trying to

I am relatively new to this and am using Access 2003. I've created a
function, ConcatList(stWhichForm, stWhichCntl), that concatenates listbox
selections for use as parameters for a series of reports. On the selection
form, frmRoomParameters, I have created a hidden text box for ...

I have the table F1UTc
CodAutonumber (PK)
CodFarmer (FK)
CodSemester (FK)

Sample list of records:
   DATE      LAST_NM FIRST_NM INT_ID OTHER
1) 20070301 DOE        JANE         12345  XXXXXXX
2) 20061102 DOE        JANE         12345  XXXXXXX