Hi,

I cant figure this one out and have searched the forums, but no one has addressed my specific problem:

I just need to count the number of values in a field ie: if I had a 100 records with a field "color" I would like to know how many records have the value "red", "blue", etc. for the "color" field. It should look like this:

red 5

blue 7

black 1

A subsummary report will not work as I need to view this in browse mode.

Thanks in advance!

Matt

The only solution I have been able to find is to loop through the whole set and use a counter for each field with a script. If anyone else has a better idea, please let me know, I would like something that is alot faster than loop and refreshes more often.

Thanks

matt

If you are selecting colors via value list, then this technique may be helpful.

Alternately, if the unique values are contained in a separate Color table, you could use a relationship based on color and a calculation of Count(rel::serial) field in the Color table.

Example attached using the Count function and two ways to use it. One using the Colors listed in a seperate table (My Colors layout). the second uses global fields and self-join relationships (MyTable).

Summary.zip

Thanks queue,

unfortunately I cannot use a value list:(

well, it looks like I was wrong, wouldnt be the first time. Thanks to both queue and sbg2 for the help.

Btw sbg2, is there a purpose for using the tilde ~ in your occurencess ?

Thats a really sweet solution, glad to see there are people waaay smarter than me (and willing to help)