Do a Find on the Date range you want and use...Defining summary fieldsUse summary fields to calculate values such as subtotals, averages, and grand totals across multiple records. For example, a summary field can display the grand total of all sales in the month of May in a report.To define summary fields:1.With the database open, choose File menu > Manage > Database.2.In the Manage Database dialog box, click the Fields tab.3.If your database contains more than one table, select the appropriate table from the Table list.4.For Field Name, type a name for the field.See About naming fields.5.For Type, select Summary.6.Click Create.JIm...
Summary fields and sub summary layout parts are designed with that purpose in mind.
This old, but still applicable tutorial on summary reports may be useful to you: Creating Filemaker Pro summary reports--Tutorial
Please use Post A Answer to post any questions about that tutorial here rather than in the tutorial thread.
Thanks, this pretty much solved the problem.