Adding calculated field to query

M0E-lnx

Registered User.
Local time
Today, 10:04
Joined
Sep 3, 2008
Messages
62
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?
 
Just write in 'a field' in the query:
YourCalculation: QRT * PRICE

and access will happily calculate it for you :)
 

Users who are viewing this thread

Back
Top Bottom