Which type of query calculates data using a sum,average,or other function and groups the results by two sets of values?
A)Crosstab query
B)Append query
C)Make table query
D)Find duplicates query

Question

Quizplus · Accepted Answer

Crosstab queries are specifically designed to calculate data using a sum, average, or other function and group the results by two sets of values. They are often used for generating summary reports and analytical data. The other query options listed do not have this capability.

Which Type of Query Calculates Data Using a Sum,average,or Other