(SOLVED) Further calculations from calculated fields in Base
Complete newbie to databases as well as SQL.
Calculated fields are quite easy.. eg; "Field Name1" + "Field Name2"
In my database I need further calculations from calculated fields within the same query.
Here is what I have so far:
BuyPrice S/H Paid TaxPaid "BuyPrice" + "S/H Paid" + "TaxPaid"
When the query runs, this outputs to a field with an alias of Total Cost
SellPrice S/H Charged "SellPrice" + "S/H Charged" - ( "SellPrice" * 0.132 + "S/H Charged" * 0.132 )
This outputs to a field with an alias of NET
This is exactly what I need, however I also need a third calculated field for Profit. I cant just enter "NET" - "Total Cost". If I create another query on top of the first one, I can reference the aliases and it works just fine but I need this to all go into the same "Table Control"
Works but it is in two separate Table Control forms
I simply don't know enough about any of this to get it to work.. any help or suggestions would be greatly appreciated
..........