Operation Manual

Figure 238: Fuel table in query
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 239: 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.
Figure 240: Query Design toolbar
Figure 241 contains the Fuel table with my entries and the query results based upon the Fuel table:
the query results are in Figure 242.
Figure 241: Fuel table
Chapter 8 Getting Started with Base | 249