Question: what is the difference between a select query and a crosstab query?
Answer: 1. This select query groups summary data vertically by employee and category. 2. A crosstab query can display the same data, but groups the data both horizontally and vertically so that the datasheet can be more compact and easier to read.