Give user ability to select different time frames on a report

[BSJoJaMAx4]

I want to give the user the ability to run a report but display records based on different user defined time frames.



So when I run the report it allows (on the Enter Parameter Value prompt) user to enter 30, 45 60 etc (to represent days). The report then looks at all records with a start date in the next x days based on what user enters

For a separate report, I want to be able to run the same report but give user (based on drop down) ability to view all reports or only those from today's date only.

Are both possible? If you need additional clarification please let me know.

[June7]

I NEVER use dynamic parameterized queries. I prefer VBA to build filter criteria. Review: http://www.allenbrowne.com/ser-62.html

Have unbound controls on a form for user input of parameters. Use code to construct filter criteria and apply to report when it opens

DoCmd.OpenReport "report name", , , strCriteria

What do you mean by 'all' reports - there is only one report object. If you want to see the report output that would have been generated two weeks ago, need to apply filter to the report so it only retrieves records from prior to that date.

[orange]

See
--Martin Green's site --Dynamic Reports.
--Allen Browne example
--Or this sample



Good luck.

[ranman256]

put a box on a form, user fills in txtDays
then the query reads it
select * from table where [days] = forms!frmRpts!txtDays