I'm new to using queries in Access and am stuck on trying to run a query from a table.
I have thousands of records with fields such as customer name, Company Name, Company Country and Balance. What I want to do is run the query to count the number of Companies within a country. As there are thousands of records one company may be in the table up to a couple hundred times. I use the count feature to count company, group by country and sum balance, as I want to know what the total balance is by country also.
The query is giving me the total number of records by country instead of companies. The balance sum seems fine.
Can anyone help.