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 "the elapsed days" < 31 then
Days30 = Days30 + 1
Else
If "the elapsed days" < 61 then
Days60 = Days60 + 1
and so forth
Any help greatly appreciated.
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 "the elapsed days" < 31 then
Days30 = Days30 + 1
Else
If "the elapsed days" < 61 then
Days60 = Days60 + 1
and so forth
Any help greatly appreciated.