Pivot Tables

[dbay]

Where can i go to learn how to make Pivot Tables in Access?

Thanks

 

[jal]

Where can i go to learn how to make Pivot Tables in Access?

Thanks

I've never created an Access pivot table but, as far as I know, a pivot table creates the same kind of display seen in crosstab queries/reports.

Do you know SQL?

If so, I can give you a cutout from my notebook that will explain (in simple terms) how to create crosstab reports using SQL.

 

[dbay]

I know some SQl, I need to learn CrossTab queries also...

 

[jal]

Sorry I forgot about you.

I'm not a very advanced programmer so don't expect my notes to be 100% reliable but they will definitely get you started on crosstab queries.

 

[Banana]

Here's MSDN reference on PivotTable. I know you were looking for something more like a tutorial which I unfortunately don't know about - you may be able to pick up something related by looking at Excel 2003 pivottable samples (but not 2007 as they changed the OM whereas Access' PivotTable comes from OWC which is more similar to 2003.

I've implemented a PivotTable and would think that it's best for a junction table where you want to use both one-side tables as either column and row headers and have value in the body. One thing that PivotTable has going for over CrossTab query is that you can have multiple column headers. If you do end up using crosstab, I have a sample of how to build a entry form using crosstab query as a base for a temporary table.

Otherwise, if you have specific questions about PivotTable, I can try and answer.

 

[dbay]

Thanks a lot guys for all the help.