Not sure if this is possible, but I have 2 queries that are seemingly 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 - I've attempted to combine these queries into one, but it doesn't seem possible.
Thanks,
julie
