[AccessD] Creating a Pivot table in Access 2000

Oleg_123 at xuppa.com Oleg_123 at xuppa.com
Mon Feb 3 13:28:00 CST 2003


Thank you Liz,
I completely forgat about transform queries... :))
seems to be working.

> 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
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



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





More information about the AccessD mailing list