AnsweredAssumed Answered

Summary... sort of

Question asked by MackyMoto on Mar 30, 2010
Latest reply on Mar 30, 2010 by MackyMoto


Summary... sort of


Using FileMaker Pro 10.0v3 on a Dual 2.5 GHz PowerPC G5 using Mac OS X 10.5.8. Been using FM since version 2.0. Database is currently not being shared or published.


This database is used to store data for a membership program. Some of the data includes: Name and address info (for domestic and international memberships), membership number, and each record includes the membership level. There are four membership levels: Basic, Plus,  Premium, and Elite.


What I would like to do is be able to tally the count of each membership level WITHOUT displaying the records. It's very easy to create a summary field and sub summary footer that accomplishes half of this goal. The problem is I have thousands of found records at any given time and don't want to page through the rather large list to find the tallies in the sub-summaries. What I would like is just a singe page showing, for example:

Basic = 10,512   Plus = 8,009   Premium = 5,222   Elite = 777


Any help would be greatly appreciated. Thanks.