Run report for last 30 days?

morfusaf

Registered User.
Local time
Today, 15:32
Joined
Apr 24, 2012
Messages
78
Ok, I am just looking for a starting point on how to get my report to only look for and display events that took place in the last 30 days(or what ever days).


Anyone have a link or something? I know its out there somewhere but my searches are comming up empty.
 
Try a criteria of

Between Date()-30 and Date()
 
... ahh Criteria... dang it, forgot about that part... HEHE my main problem is I didn't know where to put the code. . thankx again!
 
You can have the date criteria in the record source query/sql or in the Report filter.
The criteria can be Hard Coded or look to a control on your form where the operator selects what date/period to use.
 

Users who are viewing this thread

Back
Top Bottom