Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to summarize fields with Value List selections?

Status
Not open for further replies.

ratfile

Programmer
Jun 18, 2007
1
US
Using FMPro v8.5.

I'd like to create a summary field that counts the number of occurances of value list selections for a particular field. For ex. we have a field called "Activities", that can have 0+ checkboxes selected (rafting, riding, scenic flights, etc). I want to display on a report the number of boxes checked for the entire table for each of these categories (not by record, just totals).

For ex:
ACTIVITIES
Rafting 8
Riding 4
etc....

So far I cannot find a way to construct summary field(s) for this. How are the value list selections stored? Can they be parsed as plain text for regex matching?

thanks,
Bob
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top