Null Value Query

[zyus]

I hv this sample data in my table

Name PropNo RegNo Type
Mr A 123 null Steel
Mr B null 456 Wood
Mr C null null null
Mr D 789 999 Chrome

How to find record with null value in the PropNo/RegNo/Type field. In this
example records that i want are from Mr A,B and C

Thanks

 

[Irene]

hi zyus,

u try to type this sql:

SELECT Table1.Name, Table1.PropNo, Table1.RegNo, Table1.type
FROM Table1
WHERE (((Table1.PropNo) Is Null)) OR (((Table1.RegNo) Is Null)) OR
(((Table1.type) Is Null));

it should be can get the result as u want. the Table1 means your table name.
so u change the table1 to your table name. then can be run.