Access reports

I

ialami

My data tables are organized by "period" and "Year", I'am using a pop up to
enter these parameters and run a report, I would like to be able to compare
this periods data against last period. How can I display last period data?
thanks
 
A

Al Campagna

ialami,
You'll need to add another parameter to get a Start Period and End Period
Ex. Criteria...
Period
Between [Enter First Period] and [Enter Last Period]

You could do 3 to 4, or 2 to 5, etc...OR... if you do 3 to 3 the report will just
report Period 3.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
Top