How to read a table twice?

[AkelaEagle]

I have a report of taxes paid on parcel data.
The user is prompted to enter a tax year. The report returns the data for that year.

Now I need to compare the total tax paid in the year entered to the total tax paid in the previous year.
For example if the user enters "2007" the report shows detail data for tax year 2007 including a field named, "TotalTax". but now I need to modify the report to be able to go out to the same table and aquire the "TotalTax" from 2006 so that I can compare the 2006 data to the 2007 data.

I am clueless and stuck. All help is appreciatted.

Thanks!

 

[dhookom]

First, IMHO parameter prompts are never a good user interface faq701-6763. If you use a control on a form, you can create a small subreport to pull the previous year's data.

Duane
Hook'D on Access
MS Access MVP