Query between two tables

[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.

 

[Jerry Whittle]

Show us the SQL for QryLocation. Open the query in design view. Next go to
View, SQL View and copy and past it here. Information on primary keys and
relationships would be a nice touch too.

 

[LindaC]

I don't have a SQL for QryLocation. Not sure how to set it up or what to put
in the SQL. In the tblLocation the LocationID is the primary key and in the
tblArchive a field called PlusID is the primary key. Really struggling here,
so much appreciate the help.