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

    Unanswered: Can you take 2 querys and create 1 report?

    Hi, my questions is can you take the results of two queries and have them appear on the same report, and sorted correctly providing that there is a common field in both queries.

    Exmple, I have one query employee bound to table employee
    then I have probation query bound to probation table.

    Can I have those employees from the employee query and those from the probation query appear on the same report sorted by employee number which is on both queries..

    Thax so much for the help.. past and present.


  2. #2
    Join Date
    Aug 2002
    Québec, Canada
    You can use and UNION statement, but only if you have the SAME number of field for the two query:

    SELECT fld1, fld2 FROM tbl1 UNION SELECT fldOther1, fldOther2 FROM tbl2

    The Synthax may not be 100% accurate, but it is the UNION statement that is important

    JefB - hope it helps

  3. #3
    Join Date
    Sep 2002
    Thanx I figured it out

Posting Permissions

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