Summarizing totals for multiple values

[Brian J]

I use an FMP 7 database to control circulation for a trade magazine. For each subscriber record, I keep track of whether they're a buyer or seller. I do this with a "Subscriber Type" field, with a radio button value list displaying the values "Buyer" and "Seller".

I want to set up a layout that will automatically tally the numbers of each value for a monthly circulation report. I've tried some of the Summary functions, but they'll only give me a summary for one value at a time. How do I set up a summary that will give me the individual totals for each value in the list?

Thanks,

Brian

[comment]

Define a summary field as Count of (any field that cannot be empty, e.g. SubscriberID). Add a sub-summary part to your report, defined as "when sorted by Subscriber Type". Place the summary field in this part. Sort the records by Subscriber Type when producing the report.

[Brian J]

Is there a way to make it pull up the individual counts for all of the values all at once? With the process you outlined, it just shows the totals for the value that corresponds to the active record. To see counts for other values I have to navigate to records that have those values selected.

Thanks!

Brian

[comment]

It does show all the individual counts at once. But you need to be in Preview mode (or print out the report). You can delete the body part, if you like, and produce a summary only.

[Brian J]

Ah, now I see. Thanks a bunch!

Brian