What is the primary difference between a pivot table report and a cross tab query?
A)A pivot table report can contain sums, counts, and averages while a cross tab query cannot.
B)You can't pivot a cross tab query
C)A cross tab query lets you group similar items. A pitot table report does not
D)None of above

Question

Quizplus · Accepted Answer

A pivot table allows you to dynamically rearrange, sort, and filter data, which is not possible with a static cross tab query.

What Is the Primary Difference Between a Pivot Table Report