G Guest Oct 23, 2004 #1 How do I create a query in Access where all records with records that have no description (nothing entered under description)
How do I create a query in Access where all records with records that have no description (nothing entered under description)
V Van T. Dinh Oct 23, 2004 #2 Since Description is a Text Field, you may want to trap for both Null and empty String. The Query should have SQL something like: SELECT [YourTable].* FROM [YourTable] WHERE ([YourTable].[Description] Is Null) OR ([YourTable].[Description] = "")
Since Description is a Text Field, you may want to trap for both Null and empty String. The Query should have SQL something like: SELECT [YourTable].* FROM [YourTable] WHERE ([YourTable].[Description] Is Null) OR ([YourTable].[Description] = "")