• Click the field label you want to change and make your
changes as you would in any text box.
• Shorten Miscellaneous to Misc. Click Next.
5) Since we are grouping by the date, use the > button to move the
Date
field to the Grouping list. Click Next.
Figure 261: Selecting fields for grouping data
6) Sort options.
We do not want to do any additional sorting. Click Next.
7) Choose layout.
We will be using the default settings for the layout. Click Next.
8) Create report.
• Label the report: Vacation Expenses.
• Select Static report.
• Click Finished.
Note
If you feel adventurous, try selecting some of the other layout
choices. After selecting a choice, drag and drop the Report
Wizard window so that you can see what you have selected.
(Move the cursor over the Heading of this 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. Add the Fuel
table.
c) Double-click these fields in the Fuel table listing: 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#
Chapter 8 Getting Started with Base 301
Comments to this Manuals