Due Date question

T

Todd

I am using Access 2003 and the standard design query view.
I am working with a query that will drive a report of audits that are due
next month.
I have the following fields created in my query.
Audit_Len - Static
Audit_Date - date from form for when audit is completed.
Next_Mon - Caluculated as follows.
Dateadd("m",[Audit_Len],T_Programs!Audit_Date)
OverDue - Calculated as follows:
IIf(Dateadd("m",[Audit_Len],T_Programs!Audit_Date)<date(), "Yes","No")
NextMonth - Calculated as follows: Dateadd("m",13,[T_Programs]![Audit_Len])

The NextMonth is supposed to drive the report for audits that are due next
month.
This column works fine, and I see the date the audit is due next month.
I am trying to create a query from the above fields that will give me a
report of the audits that are due next month.
The report I created for overdue, works fine from the OverDue Yes/No fields.
I built the NextMonth column to help me get my report the next month due
audits.

Any help you can provide would be appreciated.

Thanks

Todd
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top