List of items not entered query

[Delboy]

Hi

In our vehicle database i have a main form with vehicle details and
subform where the mileage is entered for each week. The week no an
mileage is entered each week based upon a paper form drivers fill i
each week. I would like a query which displays which mileage value
have not been entered for a specific week no. so we can see who has no
submitted their mileage. The form and subform are linked b
vehicle_Reg.

Any help would be appreciated.

Cheers
Dere

 

[Michael Gramelspacher]

Hi

In our vehicle database i have a main form with vehicle details and a
subform where the mileage is entered for each week. The week no and
mileage is entered each week based upon a paper form drivers fill in
each week. I would like a query which displays which mileage values
have not been entered for a specific week no. so we can see who has not
submitted their mileage. The form and subform are linked by
vehicle_Reg.

Any help would be appreciated.

Cheers
Derek

perhaps:

SELECT vehicles.vin
FROM vehicles
WHERE NOT EXISTS (SELECT *
FROM vehiclemileage
WHERE vehiclemileage.reading_date = [Enter date]
AND vehicles.vin = vehiclemileage.vin);