GaryB
04-25-2012, 01:15 PM
I am trying to create a query that is based on 3 other queries. Lets say I have
Q1 Q2 Q3 and they all have 3 fields named the same. Job# Description and Notes, but, each query represents where a job# is with regard to production. What I want to do is have this query generate information from all 3 of them into the one I am trying to build so as I look at a job# I can tell where in the process that particular job# is. I have tried loading all 3 queries into the new query and creating all of the fields from each query with each particular field relating back the query it came from. Job# from q1, Job# from Q2, Job# from Q3. When I do this is shows multiple versions of each job#. If I try to use the join properties there doesn't seem to be any way to set it up to show which numbers are still in q1, which numbers are now in q2 and which numbers are not in q1 and q2 but are in q3 etc..... Anyone have any ideas for this.
Thanks,
Gary
Q1 Q2 Q3 and they all have 3 fields named the same. Job# Description and Notes, but, each query represents where a job# is with regard to production. What I want to do is have this query generate information from all 3 of them into the one I am trying to build so as I look at a job# I can tell where in the process that particular job# is. I have tried loading all 3 queries into the new query and creating all of the fields from each query with each particular field relating back the query it came from. Job# from q1, Job# from Q2, Job# from Q3. When I do this is shows multiple versions of each job#. If I try to use the join properties there doesn't seem to be any way to set it up to show which numbers are still in q1, which numbers are now in q2 and which numbers are not in q1 and q2 but are in q3 etc..... Anyone have any ideas for this.
Thanks,
Gary