Crosstab Query

Hi Monika

Thank you for your question

A cross tab query effectively allows the user to create a pivot table type analysis on a record set.

Imagine that you have a table of sales data showing among other things the name of the salesperson, the customer and the total value of the sale.

A cross tab query would allow you to produce a table, with the customer names as column headings, the employee name as row headings and the total sales by each employee to each customer in the data area of the table.

To create a cross tab query, build your query in the normal way and then choose the cross tab query type. You then will be asked to specify in the group by row which field will be row headings, which will be column headings and which will be the data. You can then also specify how you want your data presented. (Sum, Average etc.)

Hope this is useful

Regards

Stephen