OpenOffice.org OpenOffice - 3.0 Guia de Início Rápido descarregar pdf (Página 302)

100

101

Figure 262: Setting the criterion for a query

2) Save, name, and close the query. (Suggestion:

Vacation Fuel

Purchases.

)

Tip

When using dates in a query, enter them in numerical form MM/

DD/YYYY or DD/MM/YYYY depending upon your language's

default setting for dates (my default setting is MM/DD/YYYY).

All dates must have a # before and after it. Hence, May 25, 2007

is written #05/25/2007# or #25/5/2007depending upon your

language's default setting.

3) Open a new report.

• Right-click the

Vacation Fuel Purchases

query.

• Select

Report Wizard

from the context menu.

Note

When a new report is opened in this way, the query used to

open it is automatically selected in the Tables or Queries

dropdown list.

4) Create the report.

Use >> to move both fields from the Available Fields to the Fields

in Report list. Click Next.

5) Label fields.

Add a space to FuelCost to make it Fuel Cost (two words). Click

Next.

6) Group fields.

Click Date to highlight it. Use > to move the Date field to the

Groupings list. Click Next.

7) Choose layout.

We will be making no changes in the layout. Click Next.

8) Create report (final settings).

• Use the suggested name, which is the same as the query.

• Select Static report.

• Click Finish.

302 Getting Started with OpenOffice.org 3

1 2 ... 297 298 299 300 301 302 303 304 305 306 307 ... 432 433

Comentários a estes Manuais

Sem comentários

OpenOffice.org OpenOffice - 3.0 Guia de Início Rápido Página 302

Comentários a estes Manuais

Manuais e produtos relacionados com Software gráfico OpenOffice.org OpenOffice - 3.0