Is it possible to combine these two individual queries to one? The whole Is Null always throws a damper and curve ball on me! They work perfect indepently, but trying to reduce lines of code
Code:DELETE Left([Field With Space],3) AS Field1 FROM listABC WHERE (((Left([Field With Space],3))<>"LDA")); DELETE [listABC].[Field With Space] FROM listABC WHERE ((( [listABC].[Field With Space]) Is Null));