Records where a certain field is blank

G

gjmah

I need to create a query which only shows records where a field called L2 is
blank. This field was set up as a text field. I tried using the criteria
="" and I know that there are records where this field is blank, but I get no
results. What should I be putting in the criteria?
 
G

gjmah

I did a sort in the L2 field in my original table. After the sort I found
that records 1 to 3183 did have a blank L2 field. However when I did the
query with the Is Null in the L2 field, only 25 records came back. Why only
25 records?
 
Top