Retrieving All Records within a Certain Date Window 1

[jscter2]

Folks

Maybe someone could help me with this one...

I have a field on a form called REAUDIT_DATE
this field holds values of dates in the future. I need to be able to do a calculation in a query that will perform something like this

If the REAUDIT_DATE - system date is greater than 30 days then show me these records.

Is there an easy way of doing this using the access simple query window instead of VB?????

Thanks in advance!!!

Jscter

 

[sko]

In the criteria row under REAUDIT_DATE try

>Date()+30


Date() function returns today's date.

 

[jscter2]

Cheers that worked!