Count Unique Values in a Category

[fionny]

Hi All,

Please bare with me as im an utter noob but im hoping you can help me with something.

I want to create a query within Access which will show me the Unique values within a specific group currently im doing this in by exporting to excel and using the following formula:

=IF(SUMPRODUCT(($CO$2:$CO2=CO2)*($E$2:$E2=E2))>1,0 ,1)

and then pivoting the data

CO2 = the group
E2 = Order number


I would like to make a query that does the exact same thing with Access, how would I got about it?

Regards & Thanks,
Fionn

[rzw0wr]

try,
Iif(test,True part,False Part)

Dale

[fionny]

I got sorted I used a select distinct set to do it and worked it that way. Thanks.