Query Help

[drock99a]

I have a Preventive Maintenance database, each of my employees are respnosible for 5 of these tasks a week. When they turn in a form stating they completed this I key it into a table. I would like my query to tell me for there particular zone what has not been 14 days or older. My table lists each piece of equipment we have with a completed date field. Please help.

 

[buckeye_td]

If you only have one record for each piece of equipment and you just enter a new date into the completed date field each time the preventative maint. is done, then you just need to create a select query and in the criteria section for the completed date field, you should put < Now()-14 .

TD

 

[Andrew Fergus]

Hi, I'm not sure I understand the problem 100%. When you say this :

I would like my query to tell me for there particular zone what has not been 14 days or older.

Do you mean this :

I would like my query to tell me for their particular zone what has not been completed or returned 14 days or older.

If this is the case, how do you record which task has been given to each employee and when?

Andrew.