(Average Share Cost)
We would like to copy the Average Share Cost from the SubForm to the Main Form’s field, Net Share Cost
I weould have thought this was meaningless on it's own. Why can't you work this out on the subform. If you must show it on the main form, have an unbound control, work the value out on the subform, and just have the control source =[subformname][controlname
. You will probably need a bit of trial and error to get the precise syntax.
(Transactions Profit or Loss)
We would like to find out if this stock was profitable or a loss occurred.
If the Sold $ is greater than the (Drip$ plus Bought$) amount a profit was made and the amount will be Positive.
If the Sold $ is less than the (Drip$ plus Bought$) amount a loss occurred and the amount will be negative
if you are finding this hard to do, then your data structure might need attention. Why are you finding it hard to get at this value? How do you evaluate the profit/loss on a partial sale of a stock. do you store each purchase transaction separately, and then sell particular batches? or do you aggregate the total purchases and then sell using an average cost of the stockholding? Do you have to have both methods available?