Operation Manual

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 245).
b) Click End-Reading.
c) Click Add, and then click Close.
Figure 245: 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 both the Fuel table and End-
Reading queries.
Figure 246: 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 247: Added fields to the query
Chapter 8 Getting Started with Base | 251