Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Mar 2003
    Canton, Ohio, USA
    Thanked 0 Times in 0 Posts

    Report from more than one query (Win/XP/Access 2K)

    I'm trying to creat a report that has multiple text boxes. I can set it up just fine if I'm taking the data for each text box from the same query, but I need to bound the report to more than one query. Each text box has just one query it receives its data from but I'd like to pull data from different queries for some of the text boxes.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Report from more than one query (Win/XP/Access 2K)

    It depends on the situation.
    If you can match the queries on some field(s), you can create a new query based on the contributing queries, joined on the appropriate field(s), and use this new query as record source for the report.
    If you can't match the queries, you'll probably have to create a separate report for each query, and place these reports as subreports on a main report.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts