Crosstab Queries VS Pivot Tables.

  • Thread starter Thread starter Avid Fan
  • Start date Start date
A

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.
 
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.
 
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!
 
Back
Top