Query to find current location

[MarkSJ]

G'day

I am attempting to build a small database for my firm to keep a track of equipment. The equipment can be in one of three places. In the warehouse, out on a job or at the repairers. I want to create a query that will let me know where a piece of equipment is at any one time. I'm sure my tables are set up correctly. I have use a union query to work out when equipment is on a job or in repairs but I need one to show me where all the equipment currently is. Please see attached file. Thanking you in advance.

Mark

 

[JHB]

... I'm sure my tables are set up correctly.

Sorry - no they are not! (Maybe correctly set up if you look at the field type and the value you put into it, but else no!).
The tables tblRepairer and tblEquipRepair should only be one table, and in this table you have a indication of if an equipment is at repair or at a job.