Pivot Table from Query?

[Al]

I would like to generate a pivot table showing total
expense by vendor.

Right now I have a query that shows:

Vendor Qty. Item Unit Price Total

where Total = Qty. * Unit Price

Either I need to make "Total" a calculated field in the
table, create a pivot table from a query, or figure out
how to do the calculation in the pivot table.

There must be a way to do this.

Thanks for any help.

Al

 

[Al]

Did it. You CAN create a pivot table from a query.

Thanks for your patience.

Al