Page 16 of 23PREVNEXT

Queries II: Limit your data and calculate values

 
Expression Purpose
TotalQty: [QtyShippedNow] + [ShippedSoFar] Displays in the TotalQty field the sum of the values in the QtyShippedNow and ShippedSoFar fields. This could help you assess how much of an order has been filled.
Amt: [Quantity]*[UnitPrice] Displays in the Amt field the product of the values in the Quantity and UnitPrice fields.
PrimeFreight:Freight*1.1 Displays in the PrimeFreight field the cost of freight plus a 10 percent increase.
Total: [SubTotal]+[Tax]+[Tip] Displays in the Total field the sum of the values in the SubTotal, Tax, and Tip fields.
TotalWeeklyWage: [HourlyWages]*[DaysInWeek]*[HoursInDay] Displays in the TotalWeeklyWage field the total weekly wages by multiplying the hourly rate, the number of hours worked in a day, and the number of days worked in a week.
Examples of calculated fields.

A calculated field can add, subtract, multiply, divide, and perform other operations on your data. It can contain fields from your data, such as Price times Quantity, as well as numbers and built-in functions.

For example, you could calculate a prime service rate — perhaps for a rush job or unusual circumstances — by multiplying your freight cost to apply a 10 percent increase. You'll see more examples to the left as well as in the Quick Reference Card at the end of this course.

Page 16 of 23PREVNEXT