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.
Click the down arrow and then choose the first table or query from which you want to draw values for the report.
Click a field in the Available Fields box and then click either of the following buttons:
Add to add the selected field.
Add All to add all fields to the report.
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.
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.
Click the first field’s down arrow, and click the first field by which you want to sort the report’s contents.
If necessary, click the sort options to toggle between Ascending or Descending.
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.