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

    Summary Fields

    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

      Header

      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

      Footer

       

      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.

       

      Jason