Use the GetSummary function. Do some experiments to figure it out. Tough to explain.
. -- Steve Gerow FileMaker 8/7 Certified Developer President Abrazos Data Consulting, Inc. Pasadena, California 626.398.1506 Member FileMaker Bus. Alliance > -------Original Message------- > From: Sally Lawrence <[EMAIL PROTECTED]> > Subject: Trouble with summary report > Sent: May 28 '08 17:22 > > Hello! > I'm trying to create a report that shows the number of records with each > type of OrderType in a file. I know how to set up a layout with a > sub-summary when sorted by "fieldname" footer to get the counts of each > keycode. What I can't figure out is how to then subtotal each set. For > instance, we may have: > > OrderType: CountOrderType > AB1 2 > AB2 4 > AB3 6 > > HE1 1 > HE2 3 > HE3 1 > > I'd like a subtotal of the counts of the ABs, then a subtotal of the > counts of the HEs, etc. > > Then, I'd like a grand total of all the counts. > > I'm betting this is pretty easy to do and I'm just not getting it. Thanks > in advance for the always awseome help! > Sally Lawrence > > > ************** > Get trade secrets for amazing burgers. Watch "Cooking with Tyler Florence" > on AOL Food. > (http://food.aol.com/tyler-florence?video=4&?NCID=aolfod00030000000002)
