|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 26th, 2006, 10:28 PM
posted to microsoft.public.access.reports
|
|||
|
|||
accumulating numbers in subreport
I have a total qty for a contract in a report.
In a subreport in the detail section I have received qty by dates. How could I calculate in the subreport detail section in the additional column the qty left. Report: Contract Qty - 2,000 Subreport Date Received Qty Left Qty (I need this column???) 1/1/05 100 1,900 1/2/05 200 1,700 1/3/05 100 1,600 ..... I'm trying =SUM("Received Qty","qrySubreport","[ContractID]=" & Reports!Report!ContractID) But, it gives me some incorrect numbers. Please, advise anything. Thanks 
|
|
#2
April 27th, 2006, 12:09 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
accumulating numbers in subreport
Alex wrote:
I have a total qty for a contract in a report. In a subreport in the detail section I have received qty by dates. How could I calculate in the subreport detail section in the additional column the qty left. Report: Contract Qty - 2,000 Subreport Date Received Qty Left Qty (I need this column???) 1/1/05 100 1,900 1/2/05 200 1,700 1/3/05 100 1,600 .... I'm trying =SUM("Received Qty","qrySubreport","[ContractID]=" & Reports!Report!ContractID) But, it gives me some incorrect numbers. Add a text box named txtRunRcvd to the subreport's detail section. bind it to the Received Qty field and set its RunningSum property to Over All. Then add another text box to the detail section and set its expression to: =Parent.[Contract Qty] - txtRunRcvd -- Marsh MVP [MS Access]
|
|
#3
April 27th, 2006, 05:27 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
accumulating numbers in subreport
Thank you very much, Marshall.
It's working as a song. "Marshall Barton" wrote: Alex wrote: I have a total qty for a contract in a report. In a subreport in the detail section I have received qty by dates. How could I calculate in the subreport detail section in the additional column the qty left. Report: Contract Qty - 2,000 Subreport Date Received Qty Left Qty (I need this column???) 1/1/05 100 1,900 1/2/05 200 1,700 1/3/05 100 1,600 .... I'm trying =SUM("Received Qty","qrySubreport","[ContractID]=" & Reports!Report!ContractID) But, it gives me some incorrect numbers. Add a text box named txtRunRcvd to the subreport's detail section. bind it to the Received Qty field and set its RunningSum property to Over All. Then add another text box to the detail section and set its expression to: =Parent.[Contract Qty] - txtRunRcvd -- Marsh MVP [MS Access]
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Hiding Non-Value SubReport | AccessHelp | Setting Up & Running Reports | 4 | January 17th, 2006 10:40 PM |
| Repost-Still Suffering with Subreports | IreneJ | Setting Up & Running Reports | 9 | August 31st, 2004 04:55 AM |
| subreport not showing fully | Pam Ammond | Setting Up & Running Reports | 11 | August 19th, 2004 10:19 PM |
| SubReport No Data printing problem | Tony_VBACoder | Setting Up & Running Reports | 1 | August 9th, 2004 10:10 PM |
| Problems totalling subreport data on main report (A-2002) | Marshall Barton | Setting Up & Running Reports | 0 | June 23rd, 2004 08:01 PM |
Linear Mode
