1. CROSSTAB
- A crosstab query displays summarized values (sums, counts, and averages) from one field in a table and groups them by one set of facts listed down the left of the data sheet and another set of facts listed across the top of the datasheet.
- This query type is used to produce a data sheet that looks like an Excel spreadsheet.
In the Crosstab row, we can declare a field to be Row Heading, Column Heading and Value.
Post a Comment