Counting how many entries of various types

[helen82]

Hi,

I am having some trouble creating a query from my database.

The db consists of over 4000 contacts from a large variety of countries. In the db there is a drop down list where I have selected the specific country for each contact. Now I want to create a report to show how many contacts I have from each country. Not every country from the list is being represented (as yet), so I need the report to be flexible and applicable for when the db expands in the future.

I hope someone can help me and that my explanation is clear! Many thanks in advance.

Helen

 

[lespaul]

In the db there is a drop down list where I have selected the specific country for each contact

Does this mean you have a table with a look up field in it? (So when you open the table, you get a drop down list that shows the countries and then you select one?) If so, I would suggest reading The Evils of Lookup Fields in Tables

To your question, do you have a table that lists all the countries?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[helen82]

Yes it is a look up table. Thanks very much for this link. For now I've decided to create an individual query specific to each country, starting with the main countries of concern. That's the only way I can see how this can be done.

Thanks again.

Helen

 

[PHV]

Create a query joining your contacts and countries table then build a report based on this query and grouped by country.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886