Save reports

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13488-save-reports.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13488
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?

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

"Francophone" wrote in message
news:A50B3BD9-9A23-4BB8-9485-B72E4044032C@microsoft.com...
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13488
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13488
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

On Tue, 18 Jul 2006 19:23:01 -0700, Francophone wrote:

> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13488
> 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.

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13488
Enter 02/2006 when prompted and only records of Feb 2006 will be
returned.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail