Query return for date ranges.

[Desstro]

I have a query With fields:

MT2AuditDate (date/time) and
MT2NextAuditDue (date/time)

The NextAuditDue will always be 90 days after the AuditDate.

My question is how do I set the criteria for this record to show up in the query 30 days before the NextAuditDue date and remain in the query until the AuditDate is set to a new date?

[NTC]

One way would be to create a calculated field in a query; let's call it NextLess30 . set it to be of course using the NextAuditDate minus 30 days. (As an advanced beginner you will want to get to know the DateAdd method if you haven't already - very helpful).

So now with this value - you can easily set your criteria using your Next column and your new NextLess30.

Hope this gets you going in the right direction.

[Desstro]

Thanks a lot. That is very helpful. I haven't tried to put it into action yet but when I do I will post the answer in for forum purposes.