OpenOffice.org OpenOffice - 3.0 Schnellstart Anleitung PDF herunterladen (Seite 290)

100

101

Note

When working with a query, more than one table can be used.

Since different tables may contain the same field names, the

format for naming fields in a query is Table name and field name.

A period (.) is placed between the table name and the field name.

For example, The Lunch field of the Vacation table used in a

query has the name

Vacation.Lunch

Step 1: Select the fields.

1) Select the CD-Collection table from the dropdown list of tables.

• If the Tables selection is not

Table: CD-Collection

, click the

arrow (circled in red in Figure 241).

• Click

Table: CD-Collection

in the list to select it.

2) Select fields from the CD-Collection table in the

Available fields

list.

a) Click

AlbumTitle

, and use the > button (black oval in Figure

241) to move it to the

Fields in Query

list.

b) Move the Artist and DatePurchased fields in the same manner.

c) Use the up arrow to change the order of the fields: artist,

album, and date purchased.

• Click the

CD-Collection.Artist

field.

• Click the up arrow to move it above

CD-

Collection.AlbumTitle.

d) Click Next.

Tip

To change the order of the fields, select the field you want to

move and click the up or down arrow to move it up or down

(circled in magenta in Figure 241).

Figure 242: List of fields added to the query

Step 2: Select the sorting order.

Up to four fields can be used to sort the information of our query. A

little simple logic helps at this point. Which field is most important?

290 Getting Started with OpenOffice.org 3

1 2 ... 285 286 287 288 289 290 291 292 293 294 295 ... 432 433

Kommentare zu diesen Handbüchern

Keine Kommentare

OpenOffice.org OpenOffice - 3.0 Schnellstart Anleitung Seite 290

Kommentare zu diesen Handbüchern

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