I'm trying to create a query based off a table.
Is it possible to create a calculated field in a query?
For instance, the table has fields for QTY and PRICE
Can I create a field in the query to multiply these 2 values without adding a field to the table? If so, how is this done?
Is it possible to create a calculated field in a query?
For instance, the table has fields for QTY and PRICE
Can I create a field in the query to multiply these 2 values without adding a field to the table? If so, how is this done?