|
View Full Version : Blank date field kidzmom3 01-30-2002, 07:50 AM http://www.access-programmers.co.uk/ubb/frown.gifI have a date field in which some records are blank. I want to query those blank records, but I keep getting a "data type mismatch in criteria". I have tried IsNull, "", ##. Nothing is working! HELP! [This message has been edited by kidzmom3 (edited 01-30-2002).] paris 01-30-2002, 08:05 AM Did you try Is Null? I had a similar problem last week. I was just using Null with no success. kidzmom3 01-31-2002, 07:22 AM Thx Paris, but I have tried that and it puts quote around the IsNull and then gives me that data type error. I dont't want to use IsNotNull because I want to view all the Null date records. Any other suggestions? Rich 01-31-2002, 08:12 AM There is a space between Is and Null in sql ie Is Null kidzmom3 01-31-2002, 08:56 AM http://www.access-programmers.co.uk/ubb/smile.gifThx a Bunch!!! It worked!!!! |