Randomblink
The Irreverent Reverend
- Local time
- Today, 17:09
- 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...
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...