create a new crosstab query using the crosstab query wizard based on the workshops table. use the workshop type field for the new row heading, the location for the column heading, and subtotal the max capacity field using the sum function. name the query
