Using Summary fields to count records in related tables...
I'm having trouble getting 'Summary' fields to display correctly.
For info', I have created a List report based on the 'Site' table and it has two Sub-Summary parts:
In the SiteName sub-summary part I have 4 fields from 4 related tables and everything looks fine after Sorting. At the bottom of the report, I have a Trailing Grand Summary part which contains 4 summary fields for the 4 related tables. These are all set to be Counts so that they display the total number of records but they each display "0"