Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2002
    Posts
    10

    Unanswered: How to select multiple Queries in Report Wizard

    Hi Experts,

    I have a Simple MS-Access Application.
    It contains 5 Queries and 5 Tables ( 1 query for each table)

    I need to create a REPORT using a wizard which contains information from all the 5 Queries. How can I select "ALL THE 5 QUERIES" in a REPORT. When I open a Wizard it asks " Choose a table/query where the objects data comes from..." with which I can SELECT ONLY 1 QUERY but cannot select other 4. All the 5 Tables are NOT related with eachother so I cannot JOIN.

    Is there any way by which I can select all 5 QUERIES in my REPORT WIZARD.
    I am using Access 2000. Any help on this would be appreciated.

    Please reply to manojkithany@yahoo.com as well.

    THANKS!

    Manoj G. Kithany
    manojkithany@yahoo.com

  2. #2
    Join Date
    Sep 2002
    Location
    Coventry, Warwickshire, UK
    Posts
    74
    Unless there is a way of creating a single query from the 5 queries you cannot use them as data for a single report. A report can only take a single record source.

    What you can do is open a report which is just a container, if you like. On that report you insert 5 subreports, each subreport being being formatted to display the data provided by one of your queries.
    Roger Hampson
    XI - ecs (UK) Ltd

  3. #3
    Join Date
    Sep 2002
    Posts
    10
    Thank you Mr. Roger for your reply - really appreciate that.

    Manoj G. Kithany

Posting Permissions

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