[GrBear]

Originally Posted by Dean C

Run that query and see if it's what you want? Little confused as to what you're doing here

The select statement only returns the total of entries in the column.

I'll give an example of what I'm trying to do.

I have a custom field in the UCP, which one is "My favorite color is:" and there's a pull down of 8 options to choose from. (red, blue, green, etc..) This column is called field5.

I want to scan the column and display how many people like red, blue, green, etc.

The reason I didn't go with sabret00the's original suggestion was because then I'd have to change the code if I decided to add another option for the field (a new color).

Thanks for your suggestion though.