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