I have a form with 3 controls involved in my problem.
Let's call them "UseDdates" this is a checkbox and two date-controls
"Stardate" and "Enddate".
In the query by design window I want to use the date-field of my query to

I have several queries along the lines of the following:
SELECT tblInsp.InspID, tblInsp.I_EquipID, tblInsp.InspDate,
tblInsp.EquipMgr, DMax("InspDate","tblInsp","I_EquipID = " & [EquipID] & "
AND EquipMgr Is Not Null") AS LastInsp,

I have a table that has 7 different fields where a product name can be
entered (Product1, Product2, etc)... this is because up to 7 different
products can be affected by the one incident.  Some records may have 1
product other all 7, it will vary.

Here is the "SQL View" of the select query from Access.  I wish to return a
count of null values of the records in the status field.  I know of "nz" and
"iif" expressions but don't know where to put them in the design view or the
sql view.  In query design the first column is the ...

SELECT 5 as MyID, ActivityDate,  tblEmployee.FirstName as Employee,
WorkingHour as MyValue, "Working Hour" as MyCode from tblActivity
INNER JOIN tblEmployee on tblActivity.Employee_ID = tblEmployee.Employee_ID
WHERE  ActivityDate between cdate([forms]![frmReport]![dtpStartdate])  ...

I wish to run a select query where there are null values and the null values
are not counted.  The query runs properly but the null values are not
counted.  I have tried using expressions like the "nz" and "IIF" but keep
coming up with errors.  Odds are it is my ignorance that is ...

I'm using this formula in a report footer to obtain the count of scores
greater than 3.
=DCount("[RhymeBOYK]","qryTPRIKinderBOYCurrentYear","[RhymeBOYK]>3")
I then need to get a percentage of this dcount to the total of Count([StuID]).

i have a form with an option group (two options). if option1 is selected i
want to create a query named "query1" and delete the previous one. the query
should draw data from another query. if option2 is selected i want to create
again  a query named "query1" and delete the ...

Can anyone tell me why the following is returning only 0's? The return should
be mostly 1's based on the data in the fields it's checking. I also tried to
use the field names in the tables being queried to no avail.
Expr2: IIf([Hire Date]<1/1/2008 And [Termination Date]>1/1/2008,1 ...

The following data is output from our production control program :
   Log-in times on the floor are split between 2 fields; [Beg Hour]
and [Beg Min] (both number formatted). The problem is, if someone logs
in @ 14:02, the [Beg Min] field records just a "2", so when I

Hello, I've designed a database and I need help creating a query for it. In
the database, there are dates in the future when contracts expire. I need to
be able to create a query that allows me to pull the records that are either
30,60, 90, or 120 days away. For example, I want ...

This must be easy but I am getting no where.
Ok I want to pull out driver's under policy A123456 who have had more that
one claim in a give period of time.
I have built a query with all the required data and have sorted by the

I have a report that summarizes interactions with kids in a group home
setting.  The report is sorted by Kids name, staff name.  It identifies each
interaction with the kids.  There will be mulitple interactions on each day.  
The report is run for 1 month.  I need to be able to ...

I have a database that keeps track of an entry's date. In the query I need to
create an expression that returns only entries with an entry date in the
current calander week (rather than within the past 7 days).
Thanks!

I a query I have an experssion Field: Month: Month(Data() and it populates
the table with four... Thats good, but I need it to display March. Alway
going back a month as this is when the data was pulled. Any hints?