showing Records without data (1 Viewer)

stu_c · Aug 21, 2018

hi all
I have a database for cars and the date of when the vehicle when it is has been checked, I want to show what vehicles have never had a check date how do I do this?

I have tried to do a query Under CheckedDate and put Is Null but does not bring up any records at all.

Table1
TBLVehicleDetails
*IDVehicle (AutoNumber)
Registration
Make
Model
Engine Size

Table2
TBLVehicleChecks
*IDVehicleChecks (AutoNumber)
IDFKVehicle (Relationship With IDVehicle)
CheckedDate
CheckedBy

bob fitz · Aug 21, 2018

Are you sure you used Is Null and not IsNull?

Are you sure that you have some records with a Null value in the field?

CJ_London · Aug 21, 2018

do a left join between table1 and table2 with a criteria for checked date of is null

stu_c · Aug 21, 2018

Hi mate
I have tried both with no success

bob fitz said:
Are you sure you used Is Null and not IsNull?

Are you sure that you have some records with a Null value in the field?

bob fitz · Aug 21, 2018

What is the Data Type of the field CheckedDate in table2 ?

I repeat: Are you sure that you have some records with a Null value in the field?

CJ_London · Aug 21, 2018

I have tried both with no success

doesn't help us to help you - show the actual code you tried

showing Records without data (1 Viewer)

stu_c

Registered User.

bob fitz

AWF VIP

CJ_London

Super Moderator