This is just a starting point but I need to run 2 queries I'm guessing.  The
first query would tell me what records not to include in the second query.
Are there any examples of this?
Thanks

I need to run a query to find out % of site visits made within 10 days of
receipt of a case.  Both fields are of the date type and the site visit date
needs to contain no NULL values.
The fields are: -

I would like to have the system prompt for "What date are you evaluating
(mm/dd/yyyy)?" when a particular form is opened and then store that value for
the length of time that the user has the form open in a variable like
dEvalDate.  I know I can have a user defined criteria ...

I have a query that I'm having trouble in figuring out.  I have created a
database that is used for tracking sewer overflows at certain points in the
city.  The points in the city are labeled with a number, (i.e. 102, 103,
104,...up to 130).  These points are checked roughly 2-3 ...

I am using MS-Access 2003.
I have created a query, based on a table.
I have "input" data into a form, that the query can filter.
I created a report based on the query in question, to see the results of the

Dear all,
In a table I need to apply a calculation (a multiplication, albeit a rather
complicated one with lots of iif statements) whereby I aim to mulitply the
value in one field (called length) to many (~50) other fields in each record.

I've got a query that isn't returning the result I need.
The query is:
SELECT Str$([QuoteNo])+[SupplementaryID] AS Quote, Quotes.RecordID
FROM Quotes

I have a query which groups by the field 'Manufacturer' and by the
'SoldMonth' chosen on a form [Forms]![frmSwitchboard]![cboMonth].
The query has a calculated Expression field which counts the grouping per
Manufacturer -

in my table i have column named pno(Text)
i have values like   "ER,Jan[76J]/07k"
                           "ER,Jan[77J]/07k"
if i make find by using Ctrl+F (for the above value)

Hallo all,
I have two tables:
a table [Rooms] with the fields [room_id] and [Room number]
and

Can we get all the records instead of "First" of or "Last" of records that
meets the query criteria?
Just want to show all records. Thanks.