Creating a Report from the Data

Although it might be possible to generate useful reports from the data in a single table or query, it’s very likely that you’ll want to combine data from more than one table or query into a single report. For example, you might have product data in one table and supplier data in another table, and then want to create a report where full supplier contact information accompanies the product information. You can do that by creating a report using the Report Wizard.

Step through the Report Wizard

  1. Click the Create tab.

  2. Click Report Wizard.

  3. Click the down arrow and then choose the first table or query from which you want to draw values for the report.

  4. Click a field in the Available Fields box and then click either of the following buttons:

    1. Add to add the selected field.

    2. Add All to add all fields to the report.

  5. Click Next.

    1. If you created a report based on a query that reads in primary key values from more than one table, a wizard page appears asking you to select a preliminary grouping criteria for the report’s records. Click the name of the field by which you want to group and then click Next.

  6. If necessary, click the first field by which you want to group the report’s contents and then click Add. Repeat to add grouping levels.

  7. Click Next.

  8. Click the first field’s down arrow, and click the first field by which you want to sort the report’s contents.

  9. If necessary, click the sort options to toggle between Ascending or Descending.

  10. Click Next.

  11. Use the controls on the remaining wizard pages to select a layout, page orientation, style, and name for the report. When you’re done, click Finish.

    Step through the Report Wizard
    Step through the Report Wizard
    Step through the Report Wizard
    Step through the Report Wizard

Tip

Tip

You can remove fields from the Selected Fields pane of the Report Wizard by clicking the field name and then clicking either Remove, to remove the selected field, or clicking Remove All, to remove all fields.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset