Only show records missing fields

[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!

 

[Jeff Boyce]

Elizabeth

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

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[KARL DEWEY]

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