Access

Hi Kate,

Thank you for your question.

A Crosstab query is used when you need to analyse data from a query or table by using column and row headings. You specify your row and column headings and where the two meet or intersect you assign a data value.

E.g. Row heading = Name
Column heading = Car
Data = Salary

This example would show you the staff, the cars they drive and the salary they earn to maybe see if there is a link between your salary and the car you drive.

I hope this answers your question.

Regards

Simon