AnsweredAssumed Answered

Summary Fields

Question asked by Jason_Farnsworth on Oct 8, 2016
Latest reply on Oct 9, 2016 by Jason_Farnsworth

I seem to be missing something fundamental or I have completely lost my mind


I have three tables


Contractors | Projects | Inspections


With accompanying relationships of


1 Contractor many Projects, 1 Project many Inspections simple as it gets


I have a field in the Project Table summary | Count of Project ID


My Layout based on inspection table


Sub-Summary when sorting by Contractor ID

Sub-Summary when sorting by Project ID

Body Based on inspections details

Sub-Summary when sorting by Project ID

Trailing Grand Summary



When sorting the layout first by Contractor ID then by Project ID it looks right, it shows 1 contractor then a project then all the inspections for the project, then after each I have my summary field for the count of Project ID's each grouping show a total of 1, repeating for each project


In the trailing grand summary I also have the field for a count of Project ID's however it only shows 1 it should show 14


What am I over looking, this seems really straight forward.