OpenOffice.org OpenOffice - 3.2 Schnellstart Anleitung PDF herunterladen (Seite 299)

100

101

Figure 234: 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 235: Added fields to the query

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 236).

Type the numeral 1 (one) in the Criterion cell of this column.

Figure 236: Typing in calculation of fields

2) Calculate the distance traveled (Figure 237):

• Type "End-Reading".Odometer – Fuel.Odometer in the Field

cell.

• Type >0 in the Criterion cell.

Chapter 8 Getting Started with Base 299

Free eBook Edition

1 2 ... 294 295 296 297 298 299 300 301 302 303 304 ... 441 442

OpenOffice.org OpenOffice - 3.2 Schnellstart Anleitung Seite 299

Kommentare zu diesen Handbüchern

OpenOffice.org OpenOffice - 3.2 Schnellstart Anleitung Seite 299

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Grafiksoftware OpenOffice.org OpenOffice - 3.2