Please read my reply to your other thread for calculation fields that will get your counts.
From there you can set up a summary report to report the totals.
I know you're using filemaker 6, but the following tutorial should still give you some ideas on how to set this up:
Thanks for the reply, sorry for reposting something that is pretty close, if not the same as the other. Maybe one of the mods can combine the posts? I was pretty sure I was talking about different things here, but they kind of ended up being the same thing.
I read your tutorial that you gave in the link, very informative, thanks. I have one question though. When you use the sub-summary part, does it include all instances across the entire database (i.e from other files, layouts, etc) or is it local to that layout?
It includes data from all records in the found set that have been sorted into the same group. (Your "sorted by" or "break" field determines this.) If these records link to other tables both in this file and others, those links will be valid and you can include fields from these tables and calculations that reference them. The tutorial does that by including Invoice fields in the sub summary of a layout based on Line Items.