Why "<> #" Does Not Work in Query?

[djpearce]

I received a table with "#" in the first position for inactive records. Of the 8k+ records "DeleteCode = #" shows the correct number of inactive records when queried. However, when I use "DeleteCode <> #" I do not get any record in the query. Any Clue?

 

[KenHigg]

I received a table with "#" in the first position for inactive records. Of the 8k+ records "DeleteCode = #" shows the correct number of inactive records when queried. However, when I use "DeleteCode <> #" I do not get any record in the query. Any Clue?

"DeleteCode <> '#'"