okay, going off of your example, would this be right?

SELECT MyField1, MyField2, COUNT(MyField3) FROM MyTable GROUP BY MyField1

It should be written like this:

SELECT MyField1, MyField2, COUNT (MyField3) FROM MyTable GROUP BY MyField1, MyField2

MyField1 MyField2 MyField3
1 1 1
1 2 2
2 1 3

or do I need the third field in the group by area now?