Advanced Pivot Table Question

[jsmith3313]

How can you add more columns to a pivot table in access?

[ajetrumpet]

How can you add more columns to a pivot table in access?

add more columns to the table from which it came???

[jsmith3313]

When you are dragging and dropping the column and row headings from your table onto the pivot table template, it only lets you drag one field for the column heading. Is there a way to add more fields for column headings?

[ajetrumpet]

I don't think there is. The reason I think that is because a pivot table is meant to be just another design representation of the table data set.

[jsmith3313]

Is there any Visual Basic code that can do what I'm trying to accomplish?

[kennejd]

I'm not completely sure what you're trying trying to accomplish, but sometimes you can build a series of pivot table queries and then join them together in a new query...if you have a way to relate the pivot queries.

[murry]

I'm not sure which template you're using, but try creating one after making your table or query by going to Create -> More Forms -> Pivot Chart. That will let you drag as many fields as you want to the column and row headings. And If you have problems dragging them, just click on the Field you want in the Field List and selct the area you want the field from the drop down box on the bottom right of the Field List, and then click "Add To".