Help! Need a summary solution

[blah]

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

[blah]

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

[-Queue-]

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.

[sbg2]

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

[blah]

Thanks queue,

unfortunately I cannot use a value list:(

[blah]

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)