Hello --

I'm trying to create a report that will take some sales data and based on user provided date range (eg. 1999-2001) I want to produce a report that contains multiple columns ... once column for each year and that the individual rows will be the sales results for a list of businesses. A 3rd column will provide variance between the two selected years. Is there some secret to getting this report to format as described?

Thanks.

A crosstab (called pivot in A2K) query should do the trick. Use the wizard to build it for you and use the query as the recordsource for the report.