Create a report using AutoReport

AutoReport creates a report that displays all fields and records in the underlying table or query.

1. In the Database window, click Reports under Objects.
   
   
2. Click the New button on the Database window toolbar.
   
   
3. In the New Report dialog box, click one of the following wizards:
   • AutoReport: Columnar. Each field appears on a separate line with a label to its left.
     
     
   • AutoReport: Tabular. The fields in each record appear on one line, and the labels print once at the top of each page.
4. Click the table or query that contains the data you want to base your report on.
   
   
5. Click OK.

   Microsoft Access applies the last autoformat you used to the report. If you haven't created a report with a wizard before or haven't used the AutoFormat command on the Format menu, it uses the Standard autoformat.

Tip   You can also create a single-column report based on the open table or query or on the table or query selected in the Database window. Click AutoReport on the Insert menu, or click the arrow next to the New Object button on the toolbar, and then click AutoReport. Reports created with this method don't have a report header and footer or a page header and footer.