Finding Null of zero length strings

[Bill0722]

I have a table of about 15000 records. I need to replace some values in a fiew fields that were left blank. I was trying to search for them with the find and replace. Entering two double quotes in the find field returns nothing. Is there some other way to use find and replace to search for blank fields? Thanks

 

[traingamer]

Try 'is null' as a criteria.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[MaxEd]

Try using TRIM function on the field LEN of zero in a query with an OR condition IS NULL.

-Laughter works miracles.