Delete Query not deleting everything that fits the criteria

[steallan]

Hi
Im using a delete query to remove records. The criteria is that one field i've specified is blank.
Now it removes most of the records with a blank in this field, but not others. What reasons could it be that it wont remove these other records? There are no relationships set up on the table

 

[steallan]

Done it.

If anyone ever has the same problem here's the 411.

Blank entry in field can be null or a zero string lenght (datatype of field is text). so for a delete query you want is null or like "" in the criteria section.

Stupid Access its more like Excel than it lets on

 

[Norie]

the 411.

???

How where you trying to do it originally?