Monthly Reports from YTD Reports

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rmcompute - 18 Jan 2006 01:04 GMT

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 ?

Reply to this Message

Bob Miller - 18 Jan 2006 14:42 GMT

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.
rmcompute Wrote:

> Is there a simple solution to the following:
>
[quoted text clipped - 4 lines]
> create
> a report from the saved report and new ytd report ?

Signature

Bob Miller

Reply to this Message

Larry Linson - 18 Jan 2006 15:38 GMT

> Is there a simple solution to the following:
>
[quoted text clipped - 4 lines]
> 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

Reply to this Message