8 Replies Latest reply on Oct 9, 2016 11:29 AM by Jason_Farnsworth

    Summary Fields


      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.