Joining 3 Queries Together

[Jkittle]

Is there away to join the attached 3 queries (Q-Scrap_Not_Recorded_2_Cav_Molds, Q-Scrap_Not_Recorded_4_Cav_Molds, Q-Scrap_Not_Recorded_8_Cav_Molds)? I need a single report or query that will give me the "scrap not recorded" based on the "shift code" and "process group" fields.

I can run them separately of course but this takes more time and is not very user friendly for the production people who need the info.


Any suggestion is greatly appreciated.

Jerry

 

[Jkittle]

Is there any way I can use a union query to solve this?