• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Lesson 25. Working with Related Tables > Creating Multitable Reports

Creating Multitable Reports

Just as with forms, you can create reports that use multiple tables or queries. The process for doing so is almost exactly the same as that for creating a single-table report, which you learned in Lesson 23. Here's a quick review:

  1. Create the relationships between the tables. See Lesson 10.

  2. Start a new report by using the Report Wizard. (In the Database window, click the Reports tab, and then double-click Create report by using wizard.)

  3. Select the fields from the first table you want to use.

  4. From the Tables/Queries drop-down list, select a different table or query. Then select fields from it. This is similar to what you did with forms back in Figure 25.4.

  5. When you are finished, click Next.

  6. When asked how you want to view your data, choose one of the tables. This is the same as the selection you made for forms back in Figure 25.5. Then click Next.

  7. Continue with the wizard as usual, adding grouping, sorting, and so on. Refer to Lesson 23 if needed.

  8. When you reach the end of the wizard's process, click Finish to create your report.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint