monthly/weekly reports

[Guest]

This is probably really easy to do but I can't seem to figure it out. I have
a report that displays records from a table. Each record has a corresponding
date. Right now, the report shows every record in the table, going back more
than a year. How can I make it so the report just shows the records from the
previous week or month or whatever dates I choose. And then how do I use
this same report over and over for each month or week? Basically I just want
to hide certain records on the report (ones that were created before a
specific date). Thanks

 

[Guest]

You can base the 'record source' of the report on a query instead of on the
table.

Build the query to prompt you for the beginning/ending date doing a
parameter query. Once you get the query showing what you want, then change
the 'record source' of the report to the query.

If you need more options or a nicer way to input the beginning/ending dates,
build a form with unbound fields to input the data you want to view in your
report. Have a button on the form load the report and have the query
reference the fields on the form for the data to be used.

HTH,
James