Ok thanks for the advice i know what i have to do but i'm have gone completely blind to this. :(
Does anybody mind taking a look and seeing where i have gone wrong please?
:confused:
I have got to create a car hire db for a course i'm doing.
I have a vehicle table
I have a customer table
I have to be able to book more than one vehicle to a customer.
I tried putting vehicleID into my appointments table twice but that is wrong.
Any solution would be great.
I have to compare two tables with the result of a query to show all records in tbl1 and tbl2 tha are NOT IN Qry1
How would I format a new query to do this?