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?
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?