> run the query with a *xxxxx* around the criteria.. see if you get all the records<
No. I am trying to create a query to eliminate blank fields in a column. There are close to 14,000 entries, 6070 are blank (when using a filter). When I set "IS NOT NULL" as the criteria, it only hides 4514, leaving 1556 blank fields still visible. Likewise, if I use "IS NULL" it only shows 4514 of the blank fields. I've checked some of the fields and they really are empty, even the ones that don't work. It's really more of an annoyance as I can always just use the filter whenever I need to eliminate the blanks. This is in Access 2007, I don't know if it was the same in older versions. Brad [Non-text portions of this message have been removed]
