In database window right mouse clik, click on relationships make the links to each table.

Open query in design, Access will make the links automatically when a table is added. Add your criteria to grid then run the query. If it fails add one table get it working then add another table, continue until all is ok. I managed to get you query working in just a few minutes.
Colin