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

100

101

Figure 258: Making a field invisible in a query run

5) Rerun the query (Figure 259).

Figure 259: 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.

Note

To fully use queries requires a knowledge of mathematics and

specifically set operations (

unions, intersections, and, or,

complements,

and any combinations of these). For example, we

listed all of our criteria in one row. That means that all of these

criteria have to be met before a row of values will be created in

the query. This is how the

and

operator works on sets.

It also requires having a copy of the

Hsqldb User Guide

available

from http://hsqldb.org/.

Creating reports

Reports provide information found in the database in a useful way. In

this they are similar to queries. Reports are generated from the

database’s tables or queries. They can contain all of the fields of the

table or query or just a selected group of fields. Reports can be static

or dynamic. Static reports contain the data in the selected fields at the

time the report was created. Dynamic reports can be updated to show

the latest data.

298 Getting Started with OpenOffice.org 3

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

Comments to this Manuals

No comments

OpenOffice.org OpenOffice - 3.0 Quick Start Guide Page 298

Comments to this Manuals

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