Hello, I'm trying to create a delete query using two tables.   I want to
delete records from the first table and only use the second table for my
criteria.  The following is example of the SQL that is created.   It does not
work for some reason.  Could someone please help?   ...

I am simply trying to count records and use returned values in my
report as I do often, but for some reason I can't catch my error here.
======================== Snippet =============================
Set anirs = CurrentDb.OpenRecordset("SELECT COUNT(*) FROM

I have a query that takes information from a table with figures that are
shown to 3 decimal places. The querey in question is trying to make a count
of these records but its not showing the correct figures.
Eg I have 3 items all showing the value of 0.250 so the count record ...

When I try to save the following query, I get an "expression too complex in
query expression" error:
SELECT M.[Loan Acct #], M.PopEnterDt, IIf(MP.[chg off date] Is Not Null And
MP.[loan status]=5,"CHARGEOFF",IIf(MP.[Inventory Status] In

I have generated the criteria that I want to use to filter a sub report, into
a table (the values for this come from a list box), and since the criteria
need to be of the type >0, 1 0r 2, etc they come from a text field.
If I copy and paste the generated values directly into the ...

I'm trying to use the Max function and I'm having difficulty with setting
the query up.
I wanted to take the highest value from three fields for each category
(fldTax1,2 and 3).

Could someone please show me an example of how the first function in a quesry
works?
Thanks, Regi

This message is a re-post from 4-28-06.
I have a query in which I calculate the difference between two measurements,
Left and Right.  
My formula reads Diff: [Left] - [Right]

I am writing a query that looks up escorts trained on a certain day.
When an escort is trained, his training date is tracked inn the [All Escorts
tbl]
in the Trained field.  The Trained field is defined as a date/time field

Can anyone tell me what I can do to replace the standard error messages that
occur in my reports?  For example when deviding totals by zero the #Num!
error appears and I was hoping to include an IIf statement (or the likes of)
to replace the message with something more suitable.

I am using Access 97.  in my database.  I have a field called Reason Code
which is a combo text field.  I need to do a count on this field which I have
already done, by adding a totals field and using count to count the numbe of
fields. which works.  But I need to add two more ...

Hi
I need a function that will determine whether a date falls between two other
dates. If the date does fall within the time band, the function will return a
"yes", if it doesn't it will return a "no"

I have a table of information where I log an employees name, a role they have
done, what time they did it, and the date....
I have built a query on this to search by a) what department the employee is
on b) a filter if some of the roles c) roles again (but thistime its a count

I have 2 pivot queries wich I am joining with a union. The problem is the
number of columns dont remain equal always for both pivot queries and as a
result, I am getting error in union. So can I put a blank/null for missing
pivot columns to have same number of columns for both ...

I am using Access Data Project with SQL backend and have a table of parts
with serial numbers.  In the parts entry form, if someone enters a part with
a serial number that already exists in the table, can the user be prompted
'Serial Number already exists'?