Adding Numbers on Rpt but it adds what is in the Qry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a qry that show this:

FundID Ticker BuySellShrs Shares RemainingShares BothShares
BL16 MHK 900 26900 -200
BL16 MHK 900 26900 -1000
BL16 MHK 900 26900 -1000 -1000

My Report will Show this and I have it in the Ticker Header. It shows up
once but it adds it three times on the Report.

BuySellShrs 900
Shares 26900
Total Shrs 83400 =Sum(nz([BuySellShrs]) + nz([Shares]))

In the details part I have This

BothShares:
-200
-1000
-1000
Total -2200 =Sum(nz([BothShares]))

That works fine


Can this be fixed?
 
In the Ticker Header, add a text box with these properties:
Control Source BuySellShrs
Running Sum Over All
Name txtBuySellShrsRS
Visible No

This text box will invisibly accumulate the value of the shares, but only in
the header (not in the repeating detail.) In the Report Footer, you can then
show the total in a text box with Control Source:
=[txtBuySellShrsRS]
 
Back
Top