Current Year / Past Year Data

[mxfrail]

I have a report ...

Right now it displays Current Year Data per Sales Rep of Revenue etc.

Each row is a subreport cross tab query.

Below the Current Year data I want to place past year data right below it.

Is there a quick an easy way to do this without having to create new subreports for each row where date range is 1 (year) minus on both sides that the user puts in?

Or can I merely just take my same subreports and place them below it and add in the control source or something to filter year minus 1 to get the data?

 

[JBinQLD]

mate, If you want quick and easy, you've hit the nail on the head! I'm pondering a funkier way and will come back to you....

JB

 

[dhookom]

Why not add a Row heading in your crosstab for the year and set the criteria to display only the most recent two years. If you sort them by Year descending, you should get what you want.

Duane
Hook'D on Access
MS Access MVP