jdelano,

Thank you as well. You both are transforming my mess into something surely logical to an experienced Access user. Unfortunately my background is Word and Word VBA so much of this stuff while beautiful in expression is incomprehensible at this stage and impossible for me to create on my own.

Is what you have done here what is know as a UNION query? When I create my querys, I use the Design View to drag in tables and connect fields. Then I can sometimes following what the resulting SQL means. What do you do in the design view to cause one query to be called Left Inner, Inner, Outer etc.?