Did you try a sub summary report with a summary field 'count of' shirts
Hi Steve, thanks for answering. Yes, that's the first thing I tried. All I get is the list of departments. I am not even getting a Trailing Grand Total! I've tried Summarized individually and All Together - no luck. All i remember from the last time I did this was that it was easy!
The object of the dropdown box is to avoid misspellings of the various sizes (X-Small, Small, Medium, etc) so that we don't wind up with an assortment of 20 different uniforms. There's something that I am not doing or doing wrong, but I'm damned if I can tell what!
Sounds like your records need sorting. Sub-summary layout parts are not visible if their "sorted by" field is not included in the current sort order.
Kerp in in mind that performing a find, showing all records, etc. produce an unsorted found set.
Thanks for your reply, Steve. Looks like it'll work like a charm. I'll have to set up a similar summary page to count all the shirts of the same size as a grand summary page, but it should be a snap.
I go back to FileMaker 1 and, by the time they introduced Visual, the old way of setting scripts was 'etched in stone', so to speak. I guess it's time for an "old dog to learn a couple of new tricks".
Again, thanks a million for your help.