how to include count of a field?

  • Thread starter Thread starter Swaminathan
  • Start date Start date
S

Swaminathan

Hello,
Thanks first for any suggestions!
How can I include the count of a particular field from a
query in a form??
I have a field with many country names in a query. There
is a repetition of the same country several times.
In my form, I have a combo box with the list of countries.
I want to diplay the number of times the country has
appeared in the field.

Thanks,
With regards,
Swaminathan
 
Use a totals (aggregate query) as the source of the combobox. Something like

SELECT CountryName, Count(CountryName) as TimesUsed
FROM YourTable
GROUP BY CountryName
 
Back
Top