Query to count two (or more) fields

[Erick]

If I have a table with 2 fields :
Fld1 - Fld2
A - C
A - D
A - C
A - D
B - C
B - D
B - C
B - D

How can you create a query to count the number of each Fld1 & Fld2 combination (e.g. count of A - C, count of A - D,etc.)

 

[SydneyGeek]

Place the two fields on the query grid, then add the second one again (so you have it twice).
In the design view, click the big Sigma icon to turn it into a Totals query. You now have a Totals row in the grid. Leave the first two as Group By, change the third to Count.

Denis

 

[Erick]

Thanks Denis. I knew it would be something similar. I was adding the first 2 fields, then I was adding the same table again and linking the second fields together. I was then adding the 2nd field from the 2nd table in query and then doing a count on it...obviously it didn't give me what I wanted.

Thanks again.