Save reports

[Guest]

My database creates a report which summarizes the previous month sales
performance. I'd like the ability to save that report so that I can look at
it in the future, but don't know how. Each time the report is done it will
generate a new report so next month when I run it, I will not be able to
review last month's report.

Any suggestions?

 

[Larry Linson]

My database creates a report which summarizes the previous month sales
performance. I'd like the ability to save that report so that I can look
at
it in the future, but don't know how. Each time the report is done it
will
generate a new report so next month when I run it, I will not be able to
review last month's report.

1. Revise the Report so you can specify the time frame and run it twice, or

2. Revise the Report to show both current and previous month's data on the
same Report. (I have done summary Reports that include multiple time periods
of data for comparison that some thought were "handy".)

3. Save the Report output as a Snapshot file and download the Snapshot
Reader from the Microsoft website.

4. Visit MVP Stephen Lebans' site http://www.lebans.com and get his Snapshot
to PDF converter, then save the Adobe Acrobat (.PDF) form of each month's
Report to be read with the freely-downloadable Adobe Acrobat Reader.

Larry Linson
Microsoft Access MVP

 

[fredg]

My database creates a report which summarizes the previous month sales
performance. I'd like the ability to save that report so that I can look at
it in the future, but don't know how. Each time the report is done it will
generate a new report so next month when I run it, I will not be able to
review last month's report.

Any suggestions?

If your database is properly set up, you should be able to simply
re-run the report for any given month by using a query with criteria
on the DateField, i.e. Where Format(MyTable.DateField,"mm/yyyy") =
[What Month? mm/yyyy] as the report's record source.

Enter 02/2006 when prompted and only records of Feb 2006 will be
returned.