OpenOffice.org OpenOffice - 3.0 Quick Start Guide download pdf (Page 297)

100

101

Caution

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 252.

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

247). The results are in Figure 255.

Figure 255: Result of running the fuel economy query

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 256.

Figure 256: Query table with aliases added

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

Figure 257: 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 258.

Chapter 8 Getting Started with Base 297

1 2 ... 292 293 294 295 296 297 298 299 300 301 302 ... 432 433

Comments to this Manuals

No comments

OpenOffice.org OpenOffice - 3.0 Quick Start Guide Page 297

Comments to this Manuals

Related products and manuals for Graphics software OpenOffice.org OpenOffice - 3.0