3) Add the
FuelCost
field from the End-Reading query to the Fuel
Economy query:
• Right-click the
Fuel Economy
query and select Edit from the
context menu.
• Double-click the
FuelCost
field in the End-Reading query list
to add it to the query table at the bottom.
4) Add a calculation field to the right of the FuelCost field.
• Type the following in an Field cell in the table at the
bottom:"End-Reading".FuelCost/("End-Reading".Odometer
– Fuel.Odometer)
• Type the following in its Alias cell: cost per mile.
Note
If you use the metric system, cost per km is the appropriate
alias.
5) Save and close the query.
6) Open a new report.
Right-click the Fuel Economy query and select Report Wizard.
7) Select fields.
Move all the fields from the Available fields to the Fields in report
list. Use the >> to do so. Click Next.
8) Label fields.
Change FuelCost to Fuel Cost by placing a space between the
words. Click Next.
9) Group fields.
Use > to move the Date field to the Groupings list. Click Next.
10) Sort options: the wizard skipped this one.
11) Choose layout.
Accept the default. Click Next.
12) Create the report.
• Change the report name to Fuel Statistics.
• The default setting is Dynamic report, so no change is
necessary.
• Select Modify report layout.
• Click Finish.
304 Getting Started with OpenOffice.org 3
Comments to this Manuals