[AccessD] Creating a Pivot table in Access 2000

Oleg_123 at xuppa.com Oleg_123 at xuppa.com
Mon Feb 3 12:37:00 CST 2003


Pivot Table

Hey Guys,
I have several tables with the same structure. (column are: Filter,
Bucket, Asset/Liab, and Sum)
I want column “Bucket” to be the row field, “Asset/Liab” to be the new
column field and “Sum” to be data items. I am not sure how to do this in
Access, I assume it should a transform query? Currently I am importing
data to excel and create a pivot tables thaere, which is getting tedious
since I have to do it daily


any help would be greatly appreciated,

Oleg



-----------------------------------------
Send a Xuppa Valentine to Your Sweetheart today!
http://www.xuppa.com/greet/





More information about the AccessD mailing list