Brad
This may sound silly or I have missed a posting ......But,
is it possible that you
have spaces in the "empty" fields....???
This will appear to your sql as a field that is NOT empty.
you may have to try and run a trim function on the field
....this will remove any "empty" spaces
cheers
John Y
At 09:21 AM 29/09/2009, you wrote:
>
>
> > 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]
>
>
[Non-text portions of this message have been removed]
