Count with by-statement

[MartijnAn]

Hi All,

How can I count records with a by-statement? For example: I want to count all the citizens by city. All fields are part of the table and form.

I used dcount, but doesn't seem to work, or I am just to stupid .

Thanks in advance.

 

[namliam]

DCount works but only for 1 city, try using a "group by"-query....

Allmost feels like homework...