Run report for last 30 days?

[morfusaf]

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.

 

[pbaldy]

Try a criteria of

Between Date()-30 and Date()

 

[morfusaf]

... ahh Criteria... dang it, forgot about that part... HEHE my main problem is I didn't know where to put the code. . thankx again!

 

[pbaldy]

No problemo!

 

[PNGBill]

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.