Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    Canton, Ohio, USA
    Posts
    103
    Thanks
    0
    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
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 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
  •