Operation Manual

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 248)
2) Type ='1' in the Criterion cell of this column.
3) Leave the Visible cell of this column unchecked.
4) Calculate the distance traveled:
– Type in the Field cell.(Figure 249)
"End-Reading"."Odometer" - "Fuel"."Odometer"
– In the Alias row, type Distance.
– Type >'0' in the Criterion cell.
5) Calculate fuel economy: Type
("End-Reading"."Odometer" - "Fuel"."Odometer")/"End-
Reading"."FuelQuantity"
in the next column to the right of the word Field. (Figure 250)
6) Type Fuel Economy as the alias.
Figure 248: Typing in calculation of fields
Figure 249: Field for distance traveled calculations
252 | Getting Started with LibreOffice 5.0