crosstab queries - examing data

[Guest]

I can see where this (crosstab queries) would be useful if you just had two
criteria for which you wanted to run a function, one criteria for the
horizontal axis and one criteria for the vertical axis. I'd like to see how
we can use/summarize/examine several criteria at once in an Access table,
like the Excel pivot table. Is this possible?

 

[Wolfgang Kais]

Hello Sage.

I can see where this (crosstab queries) would be useful if you
just had two criteria for which you wanted to run a function, one
criteria for the horizontal axis and one criteria for the vertical
axis. I'd like to see how we can use/summarize/examine several
criteria at once in an Access table, like the Excel pivot table.
Is this possible?

You can have several column headings in a crosstab query, for example
one field with the same formula as the "value" field for a summary
inside the row.
But that's all. If you need more, use a pivot table. You can also use
pivot tables in access forms/reports.