totals query help. maybe simple.

[travismp]

I need help writting a math based query. Here is my data in the table:

COMPANY	PAID	COLOR
ALCO	-1	BLUE
ALCO	0	RED
ALCO	-1	BLUE
ALCO	0	BLUE
ALCO	-1	BLUE
ALCO	0	RED
ALCO	-1	RED
ALCO	0	BLUE
KMART	-1	GREEN
KMART	-1	BLUE
KMART	-1	RED
KMART	-1	RED
KMART	-1	GREEN
KMART	-1	BLUE
KMART	-1	RED
KMART	-1	BLUE
KMART	-1	GREEN
KMART	0	GREEN
KMART	0	RED
KMART	-1	RED
KMART	-1	BLUE
KMART	-1	BLUE
KMART	-1	GREEN
SEAR	0	RED
SEAR	0	BLUE
TARGET	-1	BLUE
TARGET	0	BLUE
TARGET	0	BLUE
TARGET	0	RED
TARGET	-1	RED
TARGET	0	GREEN
WALMART	-1	GREEN
WALMART	-1	GREEN
WALMART	-1	BLUE
WALMART	0	RED
WALMART	-1	GREEN
WALMART	-1	BLUE
WALMART	0	RED
WALMART	0	GREEN
WALMART	-1	GREEN

I need a total count for each color, for each company, IF the order has been paid (-1)

so the final query should looks like this:

Company	Red	Blue	Green 	Total
ALCO	1	3	0	4
WALMART	0	2	4	6
SEARS	0	0	0	0
TARGET	1	1	0	2
KMART	4	5	4	13

Can anyone help do this. If I need to explain more please let me know. Thanks.

 

[pbaldy]

Your output looks more like a crosstab query. Play with that wizard and see how it works for you.