I need to design the query that uses the query fields as input in
formula and calculates result.
e.g FIELDS ARE
[PARAMETER] [MEANResult] [STDEV] [NOOFSAMPLES]  [FUNCTION(X) ]

I have a database where several people enter work items every day and I need
to check for duplicate records after a given but not before.
Item     EntryDate
1234    1/5/06

I have two queries that I would like to combine the results.  Actually I have
one query I'd like to join with multiple others.  I have a database that
tracks trainings, so there is a tblEmployees, tblTrainings, and
tblTrainingList (this one just has a list of all trainings that ...

I have a query where I need to count the number of times a record field
(ontime) is 1 and the total number of records in the query. What is the
best way to do this?
SELECT tblPMTemp.MACHID, tblPMTemp.PROCNO, tblPMTemp.FREQ,

Is it possible to use the OutputTo action to export a query/table, but
EXCLUDE certain fields?
For example, I want have tables that use an ID field as the primary
key. But when I export, I don't want to have that Field in the excel

I'm just getting into access and I need help getting something set up.  I
have a table called Last_Week with fields LW_Rec_Ident and LW_Rec_Detail.  I
have another table called Clean_Export with fields Rec_Ident and Rec_Detail.
The Ident fields contain a code that will be the same ...

            i have created a database with good functionality i believe.
However i am a newbie and i need some help with one last mountain. I have a
table called products which is my master table if you like. The particular
fields of this table i need this functionality for are ...

I am trying the following SQL (Thank You Ofer).
SELECT DurationTable.NewID, DurationTable.ExternalSymbol,
IIf(nz(DLookUp("[ExternalSymbol]","[DurationTable]","[NewID] = " &
Nz(DMax("[NewID]","[DurationTable]","[NewID] < " &

I am trying to display a list of all field names in a particular query/table.
I am trying the code below but it only gives me one single name rather than
the whole list.
I would appreciate any help!   Table name=buyer, listbox= lstSelectFrom

Ok I need help, I have two fields in a table that I want to merge into one,
one is EMP_NUMBER and the other is EMP_GID and want to create a field
UNUMBER.  I am having a hard time finding the right steps to do this....any
help is greatly appreciated.  

SQL VIEW:
DELETE Clean_Export.*
FROM Last_Week INNER JOIN Clean_Export ON (Last_Week.LW_Rec_Ident =
Clean_Export.Rec_Ident) AND (Last_Week.LW_Rec_Detail =

Please help.
I have a form with mulitple fields (status 1, status 2, status 3) which can
contain one of four criteria (open, pending, closed, cancelled). I need to
count the number of fields depending on the criteria.

I have the following query!!!
STRSQL1 = "UPDATE tblMailingList SET tblMailingList.SelectForPrint = -1,
tblMailingList.LetrefNotes = " & "LetrefNotes " & " & Now() " & vbCrLf & "
WHERE (((tblMailingList.SelectForView)=-1));"

i'm using a2k and am starting to get the error in the heading about 'Item not
found in the collection' when i execute the following VBA code. i've read a
few questions posed of suppressing error messages in the queries group and
thought i'd finally 'gotten' how to pull this off ...

I am using access 97.  I have a field called journals, which I enter the
journals name we receive and I have a date field in which we enter date
received.  I need to do a count on the journals field.  In the query I have
added my journals field and then in the next grid I have ...