Copy data from calculated field to table (1 Viewer)

Example code has already been provided in post 4 (except I would use CurrentDb.Execute instead of RunSQL). If you really want to update all records of Investments_Purchases_SalesT (which has already been pointed out doesn't make sense):

CurrentDb.Execute "UPDATE Investments_Purchases_SalesT SET Net_Share_Cost=" & Me.AverageShareCost & ", Net_Share_Quantity=" & Me.SharesOwned

Hi Everyone

This topic is duplicated

See this thread

https://www.access-programmers.co.uk/forums/showthread.php?t=303249

Thank you, all for your assistance.

Our director is using our data base to her satisfaction.

Nicole

Adjust Data Calculated Field For Auditor

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 they request 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