Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Posts
    3

    Unanswered: Building a report from unrelated queries

    Not sure if this is possible, but I have 2 queries that are unrelated to each other that I need to put into one report.

    Situation:

    Table A is related to Table B and Table C. So, one query calculates the number of times variable x in Table A appears in TableB, another query calculates the number of times variable x in Table A appears in TableC
    (variable x is a combo box of 5 choices, 2 of which can only appear in Table B while the other 3 appear in Table C).

    Sounds all very confusing, but any ideas?

  2. #2
    Join Date
    Aug 2002
    Posts
    3

    Re: Building a report from unrelated queries

    Nevermind, I figured it out!

    Originally posted by JulieS
    Not sure if this is possible, but I have 2 queries that are unrelated to each other that I need to put into one report.

    Situation:

    Table A is related to Table B and Table C. So, one query calculates the number of times variable x in Table A appears in TableB, another query calculates the number of times variable x in Table A appears in TableC
    (variable x is a combo box of 5 choices, 2 of which can only appear in Table B while the other 3 appear in Table C).

    Sounds all very confusing, but any ideas?

Posting Permissions

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