Compliling multi step query into single query.

[dandoescode]

I'm sure this is a question that's been answered by the community multiple times, so if someone could point me to a good tutorial that would be awesome. I'm new to access, and have discovered its easy to write large queries by breaking them up into smaller queries and having each subsequent query reference the one before it. My problem now is that I want to combine these queries into a single query, so as to make it easier for anyone who comes after me to edit/understand what was done. I can't seem to find a good explanation of how to do this, but it seems like there should be a way.



Thanks.

[bcofie]

Use UNION query.

Select a1, b1,c1 from qry_1
UNION
Select a2, b2,c2 from qry_2
UNION
Select a3, b3,c3 from qry_3
Keep going

Hope this helps
Ben