help! In over my head

Help!
 How can I count the number of occurrances of data from 2 fields?

I have a table like this:
field1 field2

a        b
a        c
a        b
a       d
a       c
b       a
b       c
b       a

And would like to get results that indicate a count for the combination of the 2 fields

a b 2
a c 2
a d 1
b a 2
b c 1

Also are there any good books on doing more complicated query design?

thanks,
Bob Received on Fri Dec 15 2000 - 14:02:06 CST