Operation Manual

Figure 242: 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.
Step 6: Create the query to calculate the fuel economy.
1) Click Create Query in Design View to open a new query.
2) Add the Fuel table to the query just as you did in step 2: Add tables But, do not close the
Add Tables window.
3) Add the End-Reading query to this query.
a) Click Queries to get the list of queries in the database (Figure 243).
b) Click End-Reading.
c) Click Add, and then click Close.
Figure 243: Selecting queries to add to another query
Step 7: Add fields to the table at the bottom of the query.
We are going to calculate the fuel economy. To do this we need the FuelQuantity and distance
traveled. Since the FuelQuantity we want to use is the final odometer reading, we will use the End-
Reading query to get it. We will also use the Odometer field from the Fuel table and End-Reading
query.
Figure 244: Tables in this query
1) Double-click FuelQuantity in the End-Reading query.
250 | Getting Started with LibreOffice 4.0