Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

calculate variables for a report

Status
Not open for further replies.

stlouis

IS-IT--Management
Jan 17, 2003
1
GB
Sidebar: If I could only equate my cobol background to access!

Have a table that I perform a query to generate a report.
The query uses the DateDiff function to determine the number of elaplsed days from and entered date using Date().

What I would like to be able to do is define variables, add to them and finally report on the results.

IF &quot;the elapsed days&quot; < 31 then
Days30 = Days30 + 1
Else
If &quot;the elapsed days&quot; < 61 then
Days60 = Days60 + 1

and so forth

Any help greatly appreciated.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top