Re: Pivot Table

I don't do pivot tables in Access as I find crosstab queries have as much
functionality as I require. If this solution is for a report, you might want
to check the crosstab reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4
--
Duane Hookom
MS Access MVP

"Steve" <false@xxxxxxxxx> wrote in message
news:qUV0g.8324$i41.489@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Thanks for responding, Duane!

It's not a crosstab query, it's a Pivot Table.

The data table looks like:
TblProduct
ProductID
ProductName
Material
Color
Finish
etc

The query is based on TblProduct and sorts the ProductNames
alphabetically.

I need the Pivot table to look like:
ProductA ProductB ProductC etc
Material
Color
Finish
etc

Steve


"Duane Hookom" <DuaneAtNoSpanHookomDotNet> wrote in message
news:O9Sa$klYGHA.3848@xxxxxxxxxxxxxxxxxxxxxxx
What is your table structure and what is the current SQL view of your
crosstab that doesn't work?
--
Duane Hookom
MS Access MVP

"Steve" <false@xxxxxxxxx> wrote in message
news:veR0g.5661$sq5.2485@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
A query returns seven properties for a list of products: Property1,
Property2, Property3, etc. The properties are assigned to each product by
a combobox for each property on a form. I would like to create a Pivot
Table that displays the products across the top and the seven properties
down the left side. It would look like:
ProductA ProductB ProductC etc
Property1
Property2
Property3
etc

How do I get the seven properties to list vertically? When I drop
multiple properties in the Row drop zone, they line up horizontally
rather than vertically. I don't want the Pivot Table reversed where the
products are at the left and the properties are across the top.

Thanks!

Steve







.