how to change the table format Using SQL in MS access

[blyssz]

I have few various colored (Red, Green , Blue and other) and some of them are in a box.
I want create a table like :
Total Red Green Blue Others
In 88 5 3 25 55
Out 140 10 6 4 120
Total 228 15 9 29 175

After running select queries, I have table like :

Colors Status Count
Red In 5
Red Out 10
Other In 55
Other Out 120
Green In 3
Green Out 6
Blue In 25
Blue Out 4

Does anybody have any idea how to format the table and get the total in above mentioned form.

Thanks in advance,
Blyssz

 

[Remou]

You can try a Crosstab query.

http://lessthandot.com