Delete Query not finding records

[jimart]

I am using @;"Not Stated" in the format property of each field of a table so that Not Stated goes into the field if there is no other data entered from a form.
The problem is that I need to delete records if certain fields contain Not Stated - I have tried a delete query, but it doesn't find the Not Stated in the table when they are put in this way.

Any help with a fix or better way gladly received.....

 

[llkhoutx]

You only need to post this in one place.

 

[EMP]

Link of the other post
http://www.access-programmers.co.uk/forums/showthread.php?postid=228355#post228355