Sub-Report Totals NOT TOTALING

Randomblink

The Irreverent Reverend
Local time
Today, 16:48
Joined
Jul 23, 2001
Messages
279
I have a report of projects that the Engineers are responsible for. Some of the projects have Contract Amendments for them. I have created a report based on the project table. I have added a sub-report based on the Contract Amendment table. They are linked based on the Project ID, an autonumber generated per project.
The Contract Amendment table has 4 fields.
Project_ID / Amnd_No / Amnd_Amt / Amnd_Justification

What I want to do is create a text field on the main report that shows the sum of the Amnd_Amt field from the sub-report. I have tried several routes but keep coming up empty handed. I have already checked out the online help pages, so if someone else could help me?

Basically...

I have a field called: txt_Accumulative_Amendments

I want it to run a report listing out all projects, and on each project, I want to see a list of all Amendments AND I want the report to show the Accumulative Amendments for each project as well...

Thanks in advance...
 
Nevermind...

I figured it out...
I went into the subreport...
Created a Group Header...
Created an unbound text field that contained an expression to sum up the field I wanted summed...

Then I put an unbound in the main report that used the sum field from the subreport as the control source...

Thanks anyway...
 

Users who are viewing this thread

Back
Top Bottom