Dennis,

You can use

SELECT color, count(*) as total ;
   FROM (yourtable) ;
   GROUP BY color

to get the sub totals, and then

SELECT "all" as color, count(*) as total ;
   FROM (yourtable)

to get all of the colours. If you're careful with the literal in the second select, you colud even UNION the clauses.

Cheers,

Andrew

---

>I need to count the number of occurrences of certain field values...
>
>i.e.
>
>field ... color
>
>I need to get a count of records with values red, green, blue, etc.
>
>then a total of all records...
>
>I found a cube function which works with sql server but foxpro doesn't seem to like it...
>
>Is there another way to do this in foxpro...
>
>Thanks,
>
>Dennis