Crosstab Queries VS Pivot Tables.

[Avid Fan]

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.

 

[Arvin Meyer [MVP]]

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.

 

[Avid Fan]

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!