query by "prompt for criteria"

[yamy]

My database contains many companies in many countries.
How do I write one query that prompts for the country while the rest of the fields stay the same?
Rather than write thirty separate queries that are identical except for the "criteria"

SELECT Count(RMUserDetailsJan13,[AccountActivated]) AS [CountOfAccountActivated], Count(RMUserDetailsJan13.Registered) AS CountOfRegistered, Count(RMUserDetailJan13.ID) AS COuntOfID, RMUserdetailsJan13.[CountryName]
FROM RMUserDetailsJan13.[CountryName]
GROUPBY RMUserDetailsJan13.[CountryName]
HAVING (((RMUserDetailsJan13.[CountryName])="argentina"));

all comments welcome!
thanks
yamy

 

[TomCologne]

How about setting the Criteria for [CountryName] to:

Forms!frmName![txtCountryName]

with a txt/list/combo box on your form?

You're not alone,

TomCologne