Crosstab Queries VS Pivot Tables.

I am not entirely sure when to use one and not the other.


I suppose Crosstabs should give you some more flexibility if you want
for example the total as the first column.

I prefer using CrossTabs for 2 reasons:

1. I can easily create a report based on one.
2. I can easily export the data to Excel.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"Avid Fan" wrote in message
...

I am not entirely sure when to use one and not the other.


I suppose Crosstabs should give you some more flexibility if you want for
example the total as the first column.

On 19/04/2010 1:17 AM, Arvin Meyer [MVP] wrote:
I prefer using CrossTabs for 2 reasons:

1. I can easily create a report based on one.
2. I can easily export the data to Excel.

Both excellent points thank you!