Quantity of entrys from record set

[AHeide]

Hi All!

In a database (Access) i have many lines. In one of colomnes (Label) i have entrys "AAA", "BBB", "CCC", ... . I would like to know how many "AAA" and

how many "BBB" we have in database.

Is this possible to achieve this by using i = RecordSet.Fields (Label). ... mixad with other functions where i is an integer and RecordSet a record set?

what a SQL query cal deliver a i as
Integer, where i is quantity of lines
labeled with "AAA".

How can i do this with VBA?

Thank You all!
Alexander

[KnooKie]

SELECT Count(MyColumnName)
FROM MyTableName
GROUP BY MyColumnName