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
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