Find/Replace for a field that IsNull

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database that did not require a field, so now I need to do a
Find/Replace for the 1,000+ records that are NULL. I tried at the query level
to do a Find/Replace, but because the field IsNull, it won't recognize the
"blank" field... Is there code I can run to do a Find/Replace for the fields
that are NULL?

I have read through various code, but I am not that savvy yet.
 
maura said:
I have a database that did not require a field, so now I need to do a
Find/Replace for the 1,000+ records that are NULL. I tried at the
query level to do a Find/Replace, but because the field IsNull, it
won't recognize the "blank" field... Is there code I can run to do a
Find/Replace for the fields that are NULL?

I have read through various code, but I am not that savvy yet.
Click to expand...

Don't use Find and Replace at all. Use an UPDATE query.

UPDATE TableName
SET FieldName = SomeValue
WHERE FieldName Is Null
 
THANK YOU!!!!! I am fascinated with all of the things that you can do in
Access, but don't know about them until you need them... and I am very
appreciative for all of the responses I get here, and once again I have been
spared cracking my head open (because some days I spend a lot of time banging
it against the wall).

You have no idea how much I really do think it's great that you answer these
questions. m.
 
Back
Top