Count the number of a group in a recordset

[Ruegen]

I have a recordset loop that loops until the .eof

I need to count the number of areas, each record has an area ID number and I need to count them grouped

so if

north 1
south 2
east 2



then I have 2 areas

is there a way to count these through the recordset?

[amrut]

Use a group by query instead of looping recordset to count the records over group. If you do require to loop through recordset, you can use this query or its SQL as recordset.

[Ruegen]

Use a group by query instead of looping recordset to count the records over group. If you do require to loop through recordset, you can use this query or its SQL as recordset.

Not for this option, I need all records then tally at the same time. I have found a solution anyway and will post the code later.