Count number of records

[Davidatlamont]

Not sure if this is the right place to post . . .

I have two tables, City and Clients. Clients table indicates language spoken by client. I want to add a field to City table called Spanish that provides a number count of clients per city that speak Spanish.

Bascially searching for City=New York and Client Language=Spanish, etc.

[Davidatlamont]

Still need help on this, perhaps more detail is needed.

"City" table indicates all cities where we have clients, basically just a list of about 400 cities with misc. fields pertaining to that city.

"Client" table contains all information about individual clients, including preferred language.

I would like to add a field to "City" table that indicates how many clients per city prefer Spanish . This field will of course change as clients are added/deleted or language preference changes.

I'm sure this is not difficult, just don't sure how to handle. Thanks for any help you can give.

[bcooney]

Have a look at this.

Topic_192941.zip