Colleen

Hello Colleen, I think union query is the one you are looking for.
If you can attach your database, maybe i can give specific solution for your question.