I have a table for enquiries and need to filter the table on enquiries over 6 months old. I don't want to have to keep changing the date filter each time the report is run. Is there a way I can put something like; "TODAY LESS 180 DAYS" in the filter dialog box so this report can be run simply by pressing a button?
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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Filtering a report on a date
- Thread starter Triedit
- Start date