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

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

Outcomes