Mathematical Problem (1 Viewer)

[access2010]

All the calculations at the bottom of our SubForm works and are correct.
Our accountant would like to know what the profit or loss is for each individual equity (Symbol_Stock).
I have tried all kinds of calculations to find the Profit or loss, without success and would appreciate any assistance.

Thank you.
Nicole

 

[vhung]

Good Day...

What makes difference with your "net share cost" and "net share quantity"?

-difference between "transaction price" and "transsaction comm"?


Hence:
there should be,
Transaction Net Profit = (Transaction Total - Total Cost)

 

[arnelgp]

see Query1 if this is the correct computation.

 

[access2010]

Good Day...

What makes difference with your "net share cost" and "net share quantity"?

-difference between "transaction price" and "transsaction comm"?


Hence:
there should be,
Transaction Net Profit = (Transaction Total - Total Cost)

Thank you vhung for your suggestion.
The same equity such as Microsoft might be bought and sold 10 times and our accountant wants to know if we made a profit or had a loss on the the (10) transactions that had occurred.
Crystal

 

[access2010]

see Query1 if this is the correct computation.

Thank you, arnelgp.

 

[access2010]

Thank you, Arnelgp
You Query looks good and we will test the results this coming week.

Regards
Crystal

 

[arnelgp]

you might also want to review the table in the db.
there are "other" fields, but i don't know if they are
included in your computation.