Specific Dates in a Report

[Guest]

I am using Access 2003
Someone else created a Preventative Maintenance DB to record when PM are due
and completed. Currently in the query, the PMDue date is a formula created
by taking the "LastPM" and adding the "Freq" (=number of days later that the
PM is due) to come up with a new "PMDue" date. In the Query, under the PMDue
Date formula is a criteria "<=date()". This of course brings up pages and
pages of PM reports. We want to change this to just bring up what is due for
1 day or 1 week at a time. I tried replacing the criteria with a
"Between/And" statement so that the operator can pick his own dates. But
this did not work. Does anyone have a suggestion as to how I can fix this
temporarily?

This Db is very old and while it has served it purpose, we need to create a
totally new Db that will not only tell us what is needed and when but will
keep all of the old information also. But I do not have time for this now.
Right now, we are only looking for a fix to the current problem. I would
appreciate any help you can give me. By the way - has any come across a
template for a PM Database?

Aurora

 

[Allan Murphy]

In the criteria under the PMDue you have two options

1. Between [Enter Start date] and [Enter End Date]

2. for one day use Between Date() and Date()+1
for 1 week change Date()+7

Allan Murphy
Email: (e-mail address removed)