[AccessD] Creating a Pivot table in Access 2000

Oleg,

Unless I'm missing something, you can just create a cross tab query.  At
least at first, start a new query, choose the cross tab query wizard and go
from there.

Liz

-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of
Oleg_123 at xuppa.com
Sent: Monday, February 03, 2003 12:36 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Creating a Pivot table in Access 2000


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/


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com