Queries

Hi Mat

Thank you for your question

Open the query designer and select the tables and fields that you wish to show

Then click on the query type button on the toolbar and select CrossTab. This will add a cross tab row into the designer and you can then specify the row and column headings together with the data field. You will need to specify the function type for the datafield in the group by row of that field.

Regards

Stephen