- server 15
- pro advanced 15
I am going to try and explain what I am trying to do but I also attached an example file that I am guessing will do a much better job of explaining.
I have 4 tables one main table and 3 related tables. 2 of the related tables have one or more records with values attached to one main table record. I have all the values of the 2 related tables totaled on the main table. I then would like to make a report using the 4th table that totals all the found records values... man I am confusing myself. Please look at the attached example I think it makes it clear. The problem is the grand total and sub summarys are only showing values for the last record.
Thank you in advance for taking the time to help