
Figure 226: Tables in this query
1) Double-click FuelQuantity in the End-Reading query.
2) Double-click Odometer in the End-Reading query.
3) Double-click Odometer in the Fuel table.
Figure 227: 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.
Type the numeral 1 (one) in the Criterion cell of this column.
Figure 228: Typing in calculation of fields
2) Calculate the distance traveled:
• Type "End-Reading".Odometer – Fuel.Odometer in the Field cell.
• Type >0 in the Criterion cell.
242 Getting Started with OpenOffice.org 3.3
Comentarios a estos manuales