My question is this:
When creating a calculated field in a query, does it matter where you pull the fields from inside of the calculation?
Example:
Calculated field
Price - Cost Where both price and cost are fields in the query
or
Table!Price - Table!Cost Where both price and cost are fields in a table.
Is it a better practice to always pull fields for a calculation with the fields listed in the query?