ridiculously easy? - counting unique pairs...

[christheprogrammer]

OK, this shouls be easy. I am terrible with queries as I am a programmer and my mind works in loops much better. Anyway, say I have 2 columns in a table (obviously hypothetical):

monkey blue
chicken red
chicken blue
turtle green
chicken blue
monkey red
monkey blue

Now, I want the output to count up the unique pairs and produce the following:

monkey blue 2
chicken red 1
chicken blue 2
turtle green 1
monkey red 1

Probably a snap for somebody here - I appreciate the replies!

Cheers

Later

 

[gwog]

Chris,

I think I have an answer for you I'm just not sure how to show you here. But let me try:

I put your data in a sample table with these names:

Table Name Goofy (no offense)
Field1
Field2

Then I created a query that looks like this:

field1 field1 field2
goofy goofy goofy
count group by group by
[field1] [field2]

Hope that helps.

Lisa.

 

[swampBoogie]

select c1,c2,count(*) from t
group by c1,c2

 

[christheprogrammer]

Thanks to both of you, it was the "group by" that I needed. Cheers & great day

Later