|
|
|
|
|
|
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 Expert Level 8 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.
By Richard Rost
Click here to sign up for more FREE tips
|
|
Check out these other pages that may be of interest to you: |
|
