Question

what is a uses of cross tab query?​

Answer 1

To make summary data in Access easier to read and understand, consider using a crosstab query. A crosstab query calculates a sum, average, or other aggregate function, and then groups the results by two sets of values— one set on the side of the datasheet and the other set across the top.

Answer 2

Answer:

Function:-

To perform aggregate function calculations on the values of one database field and display the results in a spreadsheet format.