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

100

101

Note

If you feel adventurous, try selecting some of the other layout

choices. After selecting a choice, drag the Report Wizard

window out of the way so that you can see what you have

selected. (Move the cursor over the Title Bar of the window, and

then drag and drop.)

Vacation fuel report

1) Create a query containing only fuel bought on the days of the

vacation.

a) Open a query in Design View.

b) Follow the steps for adding tables in “Add tables” on page 296

to add the Fuel table.

c) In the Fuel table, double-click Date and FuelCost to enter

them in the table at the bottom of the query.

d) In the Criterion cell of the Date field, type the following:

BETWEEN #5/25/2007# AND #5/26/2007#

Figure 246: 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).

Each date must have a # before and after it. Hence, May 25,

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

your language’s default setting for dates.

3) Open a new report.

• Right-click the Vacation Fuel Purchases query.

• Select Report Wizard from the pop-up 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 in the Report Wizard.

Chapter 8 Getting Started with Base 305

Free eBook Edition

1 2 ... 300 301 302 303 304 305 306 307 308 309 310 ... 441 442

OpenOffice.org OpenOffice - 3.2 Schnellstart Anleitung Seite 305

Kommentare zu diesen Handbüchern

OpenOffice.org OpenOffice - 3.2 Schnellstart Anleitung Seite 305

Kommentare zu diesen Handbüchern

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