I currently have two tables, where one holds information about vehicles and another table that has entries on those vehicles being hired out to people. On the second table I have a field called "Finished" which determines whether the vehicle is back for use. The idea is that you cannot hire out the same vehicle and create a new entry while the previous entry of that same vehicle is still hired out.
I want to be able to create a query where it lists all the vehicles that do not have an entry in the Hiring table where one of the entries has "Finished" left False. (It is a Yes/No). That, I have no problem with, but I also want it to list the vehicles that do not have an entry at all in the second table in the event where I add a new vehicle in and it hasn't been hired out before. I am using this query to display all the available vehicles for when I create a Hire Out form.
Here is the SQL code I pulled from Access. It currently only displays the Available vehicles which do have an entry in the second table.
SELECT tblVehicles.RegoID, tblVehicles.Type, tblVehicles.Price, qryFinishedHire.RegoID, qryFinishedHire.Finished FROM tblVehicles LEFT JOIN qryFinishedHire ON tblVehicles.[RegoID] = qryFinishedHire.[RegoID] WHERE (((qryFinishedHire.Finished)=True));
I currently cannot find any way to have it also display the available vehicles which do not have an entry in the second table. Is this a matter of having to learn SQL code and doing it manually?
Thanks in advance.