Mimicking Excel PivotTables in Access Reports

[Guest]

I am an Access beginner. I am trying to improve the way my company generates
reports. Currently, data is put into a master table in Excel. The data is
manipulated with PivotTables to calculate the appropriate summary numbers. I
am trying to produce Access reports that simulate all of the manual
manipulations done on the PivotTable and produce the final form
instantaneously. I am having some difficulty with sorting and filtering
columns. I would like to report on the total volume purchased with each
different client as each row and each different service offered as each
column. However, I cannot figure out a way to make the columns behave as
they do in a PivotTable in Excel. I would like the report to be able to sort
the columns from left to right in descending order by the sum of the volume
of each service. Although there are many services, I would only like columns
for those that did business during the selected time frame. Any ideas on how
to accommodate these parameters and have the corrections be automatically
generated with the report is opened would be greatly appreciated.

 

[Duane Hookom]

There are demos of several crosstab query reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. None of them sort the
columns from left to right by a calculated value.