access2010
Registered User.
- Local time
- Today, 03:34
- Joined
- Dec 26, 2009
- Messages
- 1,021
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
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