OpenOffice.org OpenOffice - 3.2 Guía de inicio rápido descargar pdf (Pagina 300)

100

101

Figure 237: Field for distance traveled

calculations

3) Calculate fuel economy (Figure 238):

Type ("End-Reading".Odometer – Fuel.Odometer)/"End-

Reading".FuelQuantity in the next column to the right of the

word Field.

Figure 238: Fuel economy calculation field

Note

When entering fields for these calculations, you must follow

this format: table or query name followed by a period follow by

the field name. For hyphenated or multiple-word names (table

or query), use double quotes around the table or query name.

The query will then add the rest of the double quotes as in

Figure 236.

Use the arithmetical symbol between the two. More than one

calculation can be done by using parentheses to group the

arithmetical operations.

Step 9: Run the query and make some modification.

After we run the query to make sure it works correctly, we will hide all

of the fields that we do not need.

1) Click the Run Query icon in the Design Query toolbar (Figure

231). The results are in Figure 239.

Figure 239: Result of running the fuel economy query

300 Getting Started with OpenOffice.org 3.x

Free eBook Edition

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

OpenOffice.org OpenOffice - 3.2 Guía de inicio rápido Pagina 300

Comentarios a estos manuales

OpenOffice.org OpenOffice - 3.2 Guía de inicio rápido Pagina 300

Comentarios a estos manuales

Relacionado con productos y manuales para Software De Gráficos OpenOffice.org OpenOffice - 3.2