I know this should be simple. But I just can't remember how to do this.

I just want to count the number of unique countries in a table.

i.e. Table
Field1=Name, Field2=Country

Dan, Canada
Steve, Canada
Dave, USA
Fred, England

I just want a query / Report to give me the results:

Countries = 3


This simple solution has eluded me for 30 minutes now.

Thx
Dan

SELECT count(country) from Table;

You may have to GROUP BY country if more than 1 fields selected, but it is
not necessary for just one field.

(I had to look it up, too .. and I teach this stuff! )


"kdaniel7979" wrote:

> I know this should be simple. But I just can't remember how to do this.
>
> I just want to count the number of unique countries in a table.
>
> i.e. Table
> Field1=Name, Field2=Country
>
> Dan, Canada
> Steve, Canada
> Dave, USA
> Fred, England
>
> I just want a query / Report to give me the results:
>
> Countries = 3
>
>
> This simple solution has eluded me for 30 minutes now.
>
> Thx
> Dan
>
>

Thanks,
When I had a mutli field query it wasn't working, which is why I had
trouble figuring it out. Then after I created a very basic query it
worked fine.

Cheers