I have a report that is grouped on
Quarter (startdate of meeting, printed for each quarter)
Status of event (ContractStatusID)
Row data is displayed in the MeetingID header (GH3a); this is info on the meeting (ie. name, fees, etc.) Then there is meetingID change data (in tblMeeting_changes, connected to tblMeeting) displayed in GH3b and the detail section of the report. This table tracks and stores data that a user has changed on the main meetingID record. My main issue in this report is that I am trying to sum up quarterly data across all statuses in the report footer, as well as by quarter and by status in the report footer. I could not make these totals get anywhere near correct, since it would add up the fees multiple times (for as many records as there were in the meeting changes table). I was advised to use the "next" function along with meetingID<>meetingID formula. I tried this in the RT on evaluate using a formula. It works most of the time, but of course that's not good enough. It doesn't work when there is a row of data at the end of a status with multiple change rows...it just skips it altogether. I have attached design and report view images to help.
Any help is appreciated...I am at my wit's end with this one.