counts needed on all unique variables in a field

[learnfox2]

Hello,
if I want a total count on all unique values in a specific field what is the command?

I rememeber something like

count(*) for fieldname.....

or something like that. Keep in mind I only want to count each line once.

Thanks

 

[DSummZZZ]

Try:

SELECT somefield, COUNT(somefield) as nHowmany FROM sometable;
   GROUP BY somefield;
   ORDER BY somefield

-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[TamarGranor]

Are you trying to find out how many different values there are or how many there are of each value. Dave's answer tells you how many of each.

For how many different values, try:

SELECT COUNT(DISTINCT fieldname) AS UniqueValues ;
  FROM YourTable ;
  INTO CURSOR UniqueCount

Tamar