Basic Filter Problem

[Ste4en]

Attached is a database with one table of 3,304 rows. If I do a Filter by selection or filter by form for "deleted" I get 33 records. However when I do a filter for <> "deleted" I do not get 3,304-210 = 3,271 rows; I get 210 rows.

What am I doing wrong.

The problem appears to be that the blank fields are excluded when I run the <> "deleted" filter. How would I restate the filter to include all blank fields as well and why would it do this anyway.

Thanks

 

[Sammy B]

Try this.

Sam

 

[Ste4en]

Thanks both, I have been using Access for sometime and seem to have missed this. All working now.