Only show records missing fields

E

Elizabeth

I am trying to run a query that will show me only records that are missing
fields, but I can not get it to work. Please help!
 
J

Jeff Boyce

Elizabeth

Please post the SQL of what you are using now...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
K

KARL DEWEY

SELECT [YourTable].*
FROM [YourTable]
WHERE [Field1] Is Null OR [Field2] Is Null OR [Field3] Is Null;
 
Top