Operation Manual

Step 3: Add fields to the table at the bottom
1) Double-click the FuelID field in the Fuel table.
2) Double-click the Odometer field.
3) Double-click the FuelQuantity field.
The table at the bottom of the query window should now have three columns.
Figure 241: Query table
Step 4: Set the criterion for the query
We want the query’s FuelID to begin with the numeral 1.
1) Type >0 in the Criterion cell under FuelID in the query table.
2) Click the Run Query icon in the Query Design toolbar. (Circled in Red.)
Figure 242: Query Design toolbar
Figure 243 contains the Fuel table with my entries. The query results based upon the Fuel table
are in Figure 244.
Figure 243: Fuel table
Figure 244: Query of Fuel table
Step 5: Save and close the query
Since this query contains the final odometer reading for our calculations, name it End-Reading
when saving it. Then close the query. Now click the Save icon in the main database window.
250 | Getting Started with LibreOffice 5.0