Operation Manual

2) Double-click Odometer in the End-Reading query.
3) Double-click Odometer in the Fuel table.
Figure 245: Added fields to the query
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.
2) Type the numeral 1 (one) in the Criterion cell of this column.
3) Calculate the distance traveled:
• Type "End-Reading"."Odometer" – "Fuel"."Odometer" in the Field cell.
• Type >0 in the Criterion cell.
4) Calculate fuel economy: Type ("End-Reading"."Odometer" –
"Fuel"."Odometer")/"End-Reading"."FuelQuantity" in the next column to the
right of the word Field.
Figure 246: Typing in calculation of fields
Chapter 8 Getting Started with Base | 251