Query country

[Guest]

I would to find out how many countries I have registered in. How can I find
that out with a code in my query. I only want to show one country name of
each country only so I can tell my manager which country we need to register
our products in. thanks.

 

[Guest]

You've given us very little information to go on, but a query like this might
be what you need:

SELECT Distinct Country FROM tblSales ORDER BY Country;

where the name of the field for the country or country code is "country",
and the name of the applicable table is "tblSales". Make the appropriate
substitutions in your case.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Thanks Tom. That was what I needed...YOU ARE THE MAN!!!

 

[Guest]

Glad I could help. Good luck on your project!


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[John Vinson]

I would to find out how many countries I have registered in. How can I find
that out with a code in my query. I only want to show one country name of
each country only so I can tell my manager which country we need to register
our products in. thanks.

A Totals query based on a SELECT DISTINCT query should work - but you
have chosen not to post any information about your tables or how the
country is recorded, so it's hard to be specific.

John W. Vinson[MVP]