Adding a Subreport to a Report To create a report by using a wizard
On the Objects bar, click the table on which you want to base your report.
On the Insert menu, click Report to display the New Report dialog box.
Double-click Report Wizard.
Follow the instructions of the Report Wizard, and then click Finish to preview the report.
Modifying a Report To change the height of a report section
Open the report in Design view.
Point to the top of the selector of the section you want to resize, and when the pointer changes to a two-headed vertical arrow, drag the selector up or down to expand or collapse the section.
Modifying a Report To create a custom date format in a Report Header
Open the report in Design view.
Click the Toolbox button to open it, if necessary.
In the Toolbox, click the Text Box control, and then click where you want to insert the date in the Report Header section.
Click the label that was created with the new text box, and press to delete it.
Click the text box, and then press the key to display the Properties dialog box.
On the Data tab, click Control Source, enter your custom date format, for example: =Format(Date(), "dd,mm,yyyy")
, and then press .
Modifying a Report To add a group header or footer
Open the report in Design view, and then click the Sorting and Grouping button on the toolbar.
In the Group Properties area, double-click Group Header or Group Footer to change it to Yes.
Modifying a Report To report properties
Creating a Report from Scratch To use a query as the basis for a report
On the Objects bar, click Queries.
Click the query on which you want to base the report.
On the Insert menu, click Report.
Click Report Wizard, and then click OK.
Follow the wizard’s instructions, and then click Finish.
Creating a Report from Scratch To insert a title in a report
Open the report in Design view.
If the Toolbox isn’t displayed, click the Toolbox button on the toolbar.
To give the report a title, click the Label control in the Toolbox, and then click the top of the Report Header section.
Scroll down, and set the label’s font properties.
If necessary, on the Format menu, point to Size, and then click To Fit.
Move the label to the location you want it.
Creating a Report from Scratch To insert the date and time into a report
On the Insert menu, click Date and Time to display the Date and Time dialog box.
Make sure that Include Date is selected, and choose the date format you want. If you want to include the time, make sure that Include Time is selected, choose the time format, and then click OK.
Drag the new text box containing =Date() to where you want it, and adjust its width and position as needed using the buttons and boxes on the Formatting toolbar.
Creating a Report from Scratch To give a report a label
Creating a Report from Scratch To insert a page number in a report
In the Page Footer section, click Page Numbers on the Insert menu to display the Page Numbers dialog box.
Select the options you want, and then click OK.
Adding a Subreport to a Report To add a subreport to a report
Open the main report in Design view.
Open the Toolbox, if necessary, click Subform/Subreport on the Toolbox, and then click on the report where you want to insert the subreport.
Follow the instructions of the SubReport Wizard, and then click Finish.
Adding a Subreport to a Report To format a subreport
Adding a Subreport to a Report To use the Expression Builder in a text box in a report
Previewing and Printing a Report To preview a report in Print Preview or Layout Preview
Open the report in Design view.
Click the down arrow to the right of the View button to display the list of views.
Click Print Preview or Layout Preview.
On the Navigation bar, click the Next Page button to view each page of the report.
Previewing and Printing a Report To print a report