Getting Started with Open Office .org 3 part 31. This Manual Book is for anyone who wants to get up to speed quickly with the latest version . “GETTING STARTED WITH ″ introduces all software programs of the OpenOffice bundle: Writer (word processing), Calc (spreadsheets), Impress (presentations), Draw (vector drawings), Math (equation editor) and Base (database). This book was written by volunteers from the community working through and is distributed under the CreativeCommon Attribution Licence | 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. 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. If you feel adventurous try selecting some of the other layout choices. After selecting a choice drag and drop the Report Note 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 Figure 262 Setting the criterion for a query 2 Save name and close the query. Suggestion Vacation Fuel Purchases. 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 . p 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. When a new report is opened in this way the query used to Note 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 .
