Monthly Reports from YTD Reports

[Guest]

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 ?

 

[Larry Linson]

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 ?

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