Union Query

[LindaC]

I have one table called tblArchive where I have a department and a location
A1a, A1b, A1c, etc. I then have a table tbllocation where I have all the
locations listed all the way to Z9z. I want a query that lists all the
locations from tbllocation that are empty but also all the department records
that don't have a location assigned yet? Is this two separate queries or can
I somehow combine them? Thanks.
Result
QryLocation
Finance A1a
Finance A1b
Finance I want to be able to only select the available locations
if not assigned.