I have a report based on a query (Invoice). I want to add a SUM entry from another query but can't get it to work. I've tried =SUM([Queries].[Payments].[Amount]) and I've tried the same with ! instead of . but can't get it to work. What am I missing?
I have made a subreport which listed all the payments and did the SUM. It also workout, using the starting balance, if any monies are outstanding or in credit. However the subreport is obviously on a different part of the report to the invoice totals and is being missed by customers. I want to refer the the "Outstanding" box (=[StartBal]-[TotalPaid]) from the subreport like this:
Total Value £10.00
Total VAT £ 1.75
Invoice Total £11.75
Balance Outstanding £3.00
Total Amount Due £14.75
I've tried making Balance Outstanding value =[Reports].[Balance].[Outstanding] but I just get (hash)NAME? (Weirdly I've just discovered the Hash key on my laptop is broken!). I thought maybe you can't refer to a subreport since that report is open within the main report. Am I wrong and if so how to I refer to this "Outstanding" entry?