N Nomi123 New member Local time Today, 00:32 Joined Oct 6, 2011 Messages 6 Oct 6, 2011 #1 I have a simple access query where one of the fields I am pulling has blanks in it. I need the criteria command for the query not to pull records that are blank in the particular field I am pulling.
I have a simple access query where one of the fields I am pulling has blanks in it. I need the criteria command for the query not to pull records that are blank in the particular field I am pulling.
JamesMcS Keyboard-Chair Interface Local time Today, 08:32 Joined Sep 7, 2009 Messages 1,819 Oct 6, 2011 #2 Put "Is Not Null" in the criteria, should work OK.
