What is a CROSSTAB query?
“A crosstab query displays summarised values (sums, counts, and averages) from one field in a table and groups them by one set of facts listed down the left side of the datasheet and another set of facts listed across the top of the datasheet.” (Explanation from Access 97 Help). These queries can be extremely useful for providing summarised information. You may find that using the crosstab query as the source for a report proves problematic (various error messages, etc). A simple way round this is to create a second query, which is merely a simple select query that selects all the fields from the crosstab query. Then base your report on this second query. This seems to work… Example using Crosstab Query Wizard (example with only one table) As an example, suppose you wanted to see totals of bookings by Room/Hall/Court. Do the following: (a) Create a new query and choose crosstab query wizard (b) Choose the Booking table, then the [Date] field for the row headings. (c) Choose the [Room
