This seems too simple, but I just can't see how to do it. I need to query
for a date, any date. As long as MM/YY or MM/DD/YY or MM/DD/YYYY appears with
any date in a feild I need it to come up in a query. The dates are mixed into
a name feild. For example I'm currently also ...

the book says"to use the IIf functions to set the Monthly Due Field Value to
the Monthly Fee Value for MembershipStatus Field Values of Active and To zero
in all other cases" Can someone tell me what that would look like in the Zoom
Box so it will Calculate it correctly it keeps ...

Im not sure exactly how to explain this, so Ill be as detailed as possible.  
I have my relationship set up like this: "Batches" 1-------many
"Discrepancies".  The "Discrepancies" table has a field named [Amount] that I
need to add to several other fields in the "Batches" table.  ...

I have a Table called tblFleet, with the fields "Domicile" "Vehicle" and
among others, What I am been trying to do is create a form withn 2 drop
boxes, The First Drop Box must contain the Unique Values of "Domicile" after
choosing the correct "Domicile" I need tp populate the second ...

I'm having some trouble getting a query to return a value.  Here is the
expression of a field I have in a query:
ManufHrs: IIf([CBDCode]="Manufacturing",[Quantity]*[BuildingLaborHours],0)
I now have 2 potential values:  "Manufacturing" or "Manufacturing  (2-06-100)

I'm using Access 2003. I have a payroll database that has 45,000 payroll
records. I  need to create a query that will display annual and sick time
totals for each employee from the last payroll.
I can create a query that will display every annual and sick time totals

Does Access have a function like the Excel function Clean that will strip out
the Non Printable Characters in a column? I have a file that is too large to
use Excel

Sample of code I am trying to re-write recursively:
d1 = DLookup("[id]", "table")
d2 = DLookup("[id]", "table", "[id]<>" & d1)
d3 = DLookup("[id]", "table", "[id]<>" & d1 & " and [id]<>" & d2)

Friends,
thanks a lot for replying me.
But still in problem!!!!!!
I tried the query with all of you had Suggested but didn't work. So I think  

This is the actual query :
recordset rstA:
"SELECT cancelled FROM tblOrders WHERE ID_company=" & ID_comp & " ORDER BY
ID DESC"

I want to create a Query that pulls records from my table with more than one
date range. Example, Customers we did busines with between 4-01-05 thru 04-30-
05 and 04-01-06 thru 04-30-06. Currently I have a seperate query for each
year.

If I overlooked this topic being discussed previously I apologize.
Basically, I have table in Access 2003, that contains an ID field
(800,000+ numerical IDs).  I have a list of about 5,000 IDs which I
need to extract/filter from the 800,000 + IDs.  I am at a lost of how

What's the Access equivalent for the SQL Server query :
"SELECT cancelled FROM (SELECT cancelled FROM tblOrders WHERE ID_emp=20
ORDER BY ID DESC) WHERE cancelled=0"
The compiler fires an 'Error in FROM clause'

I have run a select query and now need to write some vb code to run through
the data returned from the query.
Dim rstNew As Recordset
stSQL = "Select * from xxxxxxxx"

Can anyone tell me how to round hours and minutes in a Short time field
that has times like 18:45 to have all the minutes changed to zeros and leave
the hour unchanged?
Thanks