How do I make an XY Report

[Brad]

Hi Guys,
I am trying to make a report in access which gives me results in a table.

Basically I have a table :

TABLE1(ID_Num, Area, Colour, Num_Of_Doors) and what I am trying to get is a report that says:

Number of Doors
.............Green....Red...Blue
Area1........3.........2.......1
Area2........2.........1.......6

Does that make any sense ?

Anyway I can't get it to produce anything even close , any ideas ?

 

[Rich]

Use a crosstab query

 

[Brad]

thanks for that, worked a treat