View Single Post
Old 06-25-2008, 02:52 PM   #2
MSAccessRookie
AWF VIP
 
MSAccessRookie's Avatar
 
Join Date: May 2008
Location: Central NJ, USA
Posts: 3,428
Thanks: 13
Thanked 128 Times in 123 Posts
MSAccessRookie is a jewel in the rough MSAccessRookie is a jewel in the rough MSAccessRookie is a jewel in the rough
A UNION query comes to mind. Something Like: (you tailor to your needs)

Select PartName, NumberNeeded, {whatever else you need}
FROM ((PartTable1 INNER JOIN PartTable5 ON {whatever they join on})
INNER JOIN PartTable6 ON {whatever they join on})
UNION
Select PartName, NumberNeeded, {whatever else you need}
FROM ((PartTable2 INNER JOIN PartTable5 ON {whatever they join on})
INNER JOIN PartTable6 ON {whatever they join on})
UNION
Select PartName, NumberNeeded, {whatever else you need}
FROM ((PartTable3 INNER JOIN PartTable5 ON {whatever they join on})
INNER JOIN PartTable6 ON {whatever they join on})
UNION
Select PartName, NumberNeeded, {whatever else you need}
FROM ((PartTable4 INNER JOIN PartTable5 ON {whatever they join on})
INNER JOIN PartTable6 ON {whatever they join on})

This will get you a combined list and remove duplicates for you. If you want a complete list to remove the duplicates on your own, substitute UNION ALL for UNION
__________________
No one is expected to know everything and we can all learn from each other if we try.

This forum is about taking the next step (or perhaps the next two steps) toward becoming a better Access programmer, and the AWF Forum Members will help you on your journey.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
MSAccessRookie is offline   Reply With Quote