Can Access create Pivot Table Reports

[Guest]

I current have a query that I export to excel, create a pivot table then
format it to print. I do this on a weekly basis. Can access create a Pivot
table or a report that is formatted the same as a pivot table?

Thanks in advance

 

[Duane Hookom]

You can create reports from crosstab queries.

 

[Larry Linson]

The ability to create Pivot Tables in Access began with Access 2002 (in
Office XP). As I haven't used Pivot Tables in Excel, I can't compare the two
for this purpose.

Larry Linson
Microsoft Access MVP