counting records

[Guest]

I have a database containing calibration information for test equipment. I
have two queries, one saying which equipmemt is overdue for calibration, and
one saying which equipment has a month before it's due for calibration. Is
there any way I can take a count of these two seperate queries, and put the
two results onto something like a web page, which I can then have as an
active desktop, which tells me "There are XX items due for calibration, and
there are YY items overdue for calibration"?

A novice wants to know...

Cheers

 

[Guest]

You could use a union query. Here is another solution to use a single query.
SELECT Sum(IIf([CalDueDate] < Date()+35 ,1,0)) AS [Calibration Due],
Sum(IIf([CalDueDate] < Date(),1,0)) AS [Calibration Overdue]
FROM [Calibration];
Substitute your own criteria for due and over due.

 

[Guest]

In addition to Karl's good advice; you can consider the Aggregate
functionality built into Access.

If you have an Access text book - You might want to look up the count
feature - I think it will work in your case. But it is not entirely
intuitive and helps if you have an instruction book....