Click the Reports icon in the Database list in the Automobile - window.Since fuel was purchased and entered into this table at times other than during the vacation, a query needs to be created that contains only the fuel purchased during the vacation. The second report involves the Fuel table. This report will not require an additional query. The fields we will need for the first report from the Vacations table are: Date, Motel, Toll, Breakfast, Lunch, Supper, SnackCost, and Miscellaneous. The second report will list the fuel costs each day. The first one will list the expenses each day other than fuel. In the near future, the report feature will include these abilities.įor our purposes, we will create two reports. (This would let us know where the money came from to pay the expenses.) At the present time, using the data from the queries in a spreadsheet is the best way to handle reports like this. A third possible report would list the totals for each expense group for each type of payment. Another possible report would list the expense totals for each day of the vacation. One possible report would simply list the totals of each of these expense groups. The expenses for our vacation are motel, tolls, miscellaneous, breakfast, lunch, supper, snacks, and fuel. Are there any calculations required in the data before being added to the report?.Will a query have to be created because these fields are in different tables?.What fields are required to provide this information?.How do we want the information arraigned?.What information do we want in the report?.Certain questions need to be asked before creating the report. We will create a report on vacation expenses. So this report requires creating a query. These values are contained in fields of two different tables: Vacations and Fuel. Fuel costs are one part of that report as are meal costs. Then you can create a report on this query.Īn example of this caution is creating a report on vacation expenses. If you want to use fields from different tables, you must first combine these fields in a single query.

So you need first to decide what fields you want to use in the report. All reports are based upon a single table or query.

Open office database examples