AccessKay via AccessMonster.com wrote:

Let me try to explain better. I have two text boxes on my form where a user
can pick any two periods. I initially set this up for months. But I needed
to create a report for a quarterly comparison so for example, if the user
enters 12/2009 in the first text box and 3/2010 in the second text box, I can
use those text boxes for the record source to show Qtr 4 2009, and Qtr 1 2010
under the columns of my report. I still have one column on my report that
needs a reference source for the Previous Year’s Qtr (Qtr 1 2009). I’m not
sure how to do this. Am I making better sense?


It might make more sense if I understood how you are
calculating both this year's and the previous year's month
and quarter values and see the report's record source query.

If you are asking how to calculate the previous year's
values, then I can try to figure it out from how you do it
for this years values. I'm beginning to suspect that this
year's value are calculated by using the Sum function in one
or more group and/or the report footer section text box
expressions. If so, then, depending on the report's record
source filtering, you may be able to use the DSum function
to calculate the previous year's values.

--
Marsh
MVP [MS Access]