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

100

101

Notice that not all of the last column label is visible because some

of the labels are long. We can fix this problem by using an alias

for many of the fields. The labels are replaced by their aliases.

2) Add Aliases:

Type in the aliases as they are listed in Figure 240.

Figure 240: Query table with aliases added

3) Run the query again. The results are in Figure 235.

Figure 241: Query run with aliases

We really do not need the column showing the difference between

the FuelID fields from the table and query, so we will hide it.

While it will not be visible, it will still be used in the calculations.

4) Hide a field that does not need to be seen.

Remove the check in the box of the Visible cell as in Figure 242.

Figure 242: Making a field invisible in a query run

5) Rerun the query (Figure 243).

Figure 243: Query run with aliases

Step 10: Close, save, and name the query.

My suggestion for a name is Fuel Economy.

There are obviously other calculations that can be made in this query

such as cost per distance traveled and how much of the cost belongs to

each of the payments types.

Chapter 8 Getting Started with Base 301

Free eBook Edition

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

OpenOffice.org OpenOffice - 3.2 Schnellstart Anleitung Seite 301

Kommentare zu diesen Handbüchern

OpenOffice.org OpenOffice - 3.2 Schnellstart Anleitung Seite 301

Kommentare zu diesen Handbüchern

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