Microsoft Access Calculated Query Fields
Performing Math in Query Fields
Q: How can I calculate the product of two values in a
query? For example, I'm figuring out order details, and I need to
multiply the unit cost times the quantity purchased to figure out the
line total.
A: Performing basic math in a
query is a piece of cake. To multiple two fields like you want to do,
just create a new "calculated" field like this:
=LineTotal: UnitPrice * Quantity
Here's a screen shot from one of my tutorials:
Here is a FREE VIDEO TUTORIAL
that will walk you through this topic in detail.
I teach the concepts in this free mini tutorial in my
Access 220 course. These are
full courses - over 60 minutes in length each. I spend a lot more time going
over how to do this, in addition to lots more tips and tricks.
| 
