6 mo Report

[idcowboy]

I have an access DB I created I want to keep track of cleanings on machines every 6 months what is the best way to do that. I have assigned all of the machines an ID number and I do keep track of when I do a cleaning on the machine I just don’t know how to pull a report that tells me that it has been six mo since the last cleaning …… thanks

 

[scriverb]

You should create a query of your table that analyzes the Last cleaning date and lists the machines in order of these dates that are over 6 months old.

Select A.MachineID, A.LastCleaningDate FROM [red]yourtablename[/red] as A WHERE A.LastCleaningDate <= DateAdd("m",6,Date());

The above example should help you setup a query to select the records that you want to use in your report. After the query is working then save and name it. Then use this saved query as the Record Source for your report rather than the table.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]