Pivot Table View

  • Thread starter Thread starter Stephen
  • Start date Start date
S

Stephen

I have a fairly simple query (using SQL and ADP) that looks in an order
table and returns the folowing fields for all sales details:

Item
Quantity
Size

I have been trying to set the results onto a pivot table view so I can see a
table similar to teh following:

-------------- Size 1--------Size 2--------Size 3--------Size 4
Item A 255 355 455 500
Item B 100 300 250 180
Item C 457 568 256 566
Item D 447 214 352 989

I am following the instruction to dra gna ddrop the field from teh field
chooser into the pivottable view bu I am getting the folloinw problem:

The system is NOT allowing me to setup any of the three fields as the column
headers. I cam used to using Excel where there are labeled cvolumn and row
sections to which fields ca be dropped. When I try to do this ow, it is
just dropping the fileds into teh left column so that I cannot create any
column field. My data just looks like teh origianl table:

Item A Size 1
Item A Size 2
Item A Size 3
Item B Size 1
Item B Size 2
Item B Size 3
Item C Size 1
Item C Size 2
Item C Size 3

Can someone lend me some assitance?

-Stephen
 
Hi,

With Access 2003. Open the table in data view. From the menu, the first
button on the toolbar is a "combo box" button, select the PivotTable view.
Drag Item field in the "Drop Row Fields Here", drag Size field in "Drop
Column Fields Here" and finally drag the Quantity field in the "body" part.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top