Access pivot table question

[Terrell Miller]

got a question about using pivot tables in Access.

You know how in Excel you can have the "data" fields in a pivot table
either top-to-bottom (the default) or side-by-side? I'm trying to figure
out how to do that in Access. When I add them to the data field I can
only get them side-by-side. I tried both drag-and-drop and using the
AddTo feature of the field list dialog box. Also tried adding one or
both as row selector fields or column selector fields, no joy.

What I would like the pivot table to look like is the following:


[year] --> 1999 2000 2001 2002 2003 2004 2005

[State]
AL [total] [total] [total] [total] [total] [total] [total]
[%tot] [%tot] [%tot] [%tot] [%tot] [%tot]
AR

etc.


....with two rows for each state, instead of this, the only way I can get
it in Access:

[year] --> 1999 2000 2001 2002 2003 2004 2005

[State]
AL [total] [%tot] [total] [%tot] [total] [%tot] [total] [%tot] [total]
[%tot] [total] [%tot]
AR

etc.

with two columns for each state.


Any help greatly appreciated!

 

[TPratt]

In Access a pivot table is called a Crosstab query. There's a wizard that
will walk you through it.

 

[Terrell Miller]

In Access a pivot table is called a Crosstab query. There's a wizard that
will walk you through it.

nope, starting with Access 2002 they added pivot tables and pivot
charts. Basically it's an embedded Excel object instead of something
new, but there are differences.

Crosstab queries are still there and still massively useful, but you can
do more with pivot tables. F'rinstance you can show the actual contents
of text fields in the "data" section instead of counting them, which
AFAIK you can't do in Excel. So you can do non-numeric pivots in Access,
which is way cool.

Still can't figure out how to flip the "data" fields, though...