E Elizabeth Sep 3, 2009 #1 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!
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 Sep 3, 2009 #2 Elizabeth Please post the SQL of what you are using now... Regards Jeff Boyce Microsoft Office/Access MVP
Elizabeth Please post the SQL of what you are using now... Regards Jeff Boyce Microsoft Office/Access MVP
K KARL DEWEY Sep 3, 2009 #3 SELECT [YourTable].* FROM [YourTable] WHERE [Field1] Is Null OR [Field2] Is Null OR [Field3] Is Null;
SELECT [YourTable].* FROM [YourTable] WHERE [Field1] Is Null OR [Field2] Is Null OR [Field3] Is Null;
