Create a report

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

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 the wizard that you want to use. A description of the wizard appears in the left side of the dialog box.
4. Click the table or query that contains the data you want to base your report on.

   Note  You don't need to do this step if you clicked Report Wizard in step 3— you can specify the record source for the report in the wizard.

5. Click OK.
6. Follow the instructions in the wizard.

   If the resulting report doesn't look the way you want, you can change it in Design view.

Notes

• If you want to include fields from multiple tables and queries in your report, don't click Next or Finish after selecting the fields from the first table or query in the Report Wizard. Repeat the steps to select a table or query, and pick fields that you want to include in the report, until you have selected all the required fields.

• If you click one of the AutoReport options, Microsoft Access uses the autoformat you last specified, either in the Report Wizard or using the AutoFormat command on the Format menu in Design view.

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 Design View.
4. Click the table or query that contains the data you want to base your report on. (If you want an unbound report, don't select anything from this list.)

   Tip

   If you want to create a report that uses data from more than one table, base your report on a query.

5. Click OK.

   Microsoft Access displays the report in Design view.