Monthly Reports from YTD Reports

R

rmcompute

Is there a simple solution to the following:

We run year-to-date reports monthly from which we would like to create
monthly reports by comparing last months year-to-date report to this months's
year-to-date report. Is there a simple way to save a report and then create
a report from the saved report and new ytd report ?
 
B

Bob Miller

Simple answer, No. A report is a basically a snapshot of data. You
cannot manipulate the "snapshot." If the data for this year and last
year is in the same table you will need to collect this information in
at least two queries of the same table and then bring them together in
a single query. Hope this gives you a starting point.
 
L

Larry Linson

rmcompute said:
Is there a simple solution to the following:

We run year-to-date reports monthly from which we would like to create
monthly reports by comparing last months year-to-date report to this
months's
year-to-date report. Is there a simple way to save a report and then
create
a report from the saved report and new ytd report ?
Click to expand...

If I understand that you want to save a Report and use the saved Report and
a current Reports as the Record Source for a third Report, the answer is NO,
you cannot. Reports cannot be used as a Record Source.

However, the Queries that are the RecordSource for both Reports ought to be
usable as the basis for the new Report you want to create... from your
description, I'd guess the only difference between those Queries is in the
criteria for the dates to be selected.

Larry Linson
Microsoft Access MVP
 
Top