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