Step 8: Enter the FuelID difference field.
We want the difference between the FuelID value of the Fuel table and
FuelID value of the End-Reading query to equal one (1).
1) Type "End-Reading".FuelID - Fuel.FuelID in the field to the
right of the Odometer field of the Fuel Table
(Figure 252).
Type the numeral 1 (one) in the Criterion cell of this column.
Figure 252: Typing in calculation of fields
2) Calculate the distance traveled (Figure 253):
• Type "End-Reading".Odometer – Fuel.Odometer in the Field
cell.
• Type >0 in the Criterion cell.
Figure 253: Field for distance traveled
calculations
3) Calculate fuel economy (Figure 254):
Type ("End-Reading".Odometer – Fuel.Odometer)/"End-
Reading".FuelQuantity in the Field in the next column to the
right.
Figure 254: Fuel economy calculation field
296 Getting Started with OpenOffice.org 3
Comments to this Manuals