Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Posts
    69

    Unanswered: Combine several queries in one report?

    What is the best way combine several queries and/or forms which are not related to each other in one report?

    It seems to me to much work to relate all queries to each other and unlogic to print 5 different reports if i can combine them all five in one.

  2. #2
    Join Date
    Apr 2003
    Location
    Alabama, USA
    Posts
    154
    Do you mean to combine unrelated data from several queries? Or display unrelated data from queries in one report?

    If you just have several queries and want all of that data to be shown on one report, try using sub-reports. Sub-reports pretty much the same as subforms.

    Hope this helps!
    http://AccessDB.Info

    You live and learn. At any rate, you live. - Douglas Adams

  3. #3
    Join Date
    Sep 2003
    Posts
    69
    thanks for your advise, but if i am not wrong in sub-forms you have to have at least one related field.

    What i want is combine several reports in only one. Most of the query of the reports are unrelated and difficult to get in one general query.

    Anyway i'll try with sub-reports

    thx

  4. #4
    Join Date
    Oct 2003
    Location
    US
    Posts
    343
    You can have unrelated subforms in a form as well as unelated sub reports in 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
  •