Creating over due reports

[Cam]

Hello,

I have a tool calibration database and want to create an
over due tools report. Each tool has a ID number assigned
(Key value), as the tools came back from calibration, I
enter in the database the calibration info which include
the next calibration date.

If I pull up the report by ID number, it will show me all
the calibration for this ID. I want a report to show only
the tool with the latest next calibration date that is
passed today's date (< today date).

The problem I have w/ the report is it not only show one
(latest next cal date) under the ID nubmer that is pass
due, but all records of cal less than today's date.

Any help/suggestion is greatly appreciated. Thanks

 

[Fons Ponsioen]

Filter the query for:
SELECT TOP 1 DateBase.Dates
FROM DateBase
WHERE (((DateBase.Dates)<Now()))
ORDER BY DateBase.Dates DESC;
I used a table named DatBase
I named the due date "Dates
Basically I just sorted all duedates < now() in a
descending order and set the top value property to 1.
Hope this helps
Fons

 

[Cam]

Hi Fons,

Thanks for the help. What do you mean by set the top value
property to 1? where to you set this value?

 

[Fons Ponsioen]

Hi Cam.
While you have the query open in desing view, right click
in the gray field of the top band (in the same field where
the table(s) are showing. open the properties window, in
the properties window you'll see the top values property,
you cna set this to 1 in order to select just the top
value.
Hope this helps.
Fons