Adjust Calculated Data Field For Auditor (1 Viewer)

[access2010]

A government auditor has requested that we change our cost Average for the Equities that we own.
Can we please receive assistance on their request for a change to our Equity Calculations on our form [01=P+S] in the attached Database
===
The calculation that the Auditor has requested is shown below.
===
The average share cost should be changed and grouped by the [Bought_$] grouping.
If, the Transaction Type = [Bought_$]
Add up all the Quantity of Stocks that have been BOUGHT = [StocksBought_#]
Add up all the TransactionTotals of the stocks PURCHASED = [TransactionTotals_$]
Divide the [TransactionTotals_$] by [StocksBought_#] = [AverageShare_Cos$]
===
Your assistance will be appreciated.
Thank you,
Maria

 

[Ranman256]

in the form footer add 3 fields:
copy [bought] to the footer
copy [PURCHASED] to the footer
add empty text box

alter control source of BOUGHT to =SUM(BOUGHT)
name the textbox name to Btot

alter control source of PURCHASED to =SUM(PURCHASED)
name the textbox name to Ptot

the empty text box source = Ptot/Btot
(or the correct formula you want)

 

[access2010]

Ranman256
Thank you for your suggestion, which an other volunteer and myself tried without success.

Would you please enter your suggestion into our database and then upload your corrected version?

Thank you,
Nicole