Replace with - when data field is empty

[jmarr02s]

Hi,
How do I replace with when the field is empty?
Thanks!
jmarr02s

[Rick Wannall]

"replace with then the field is empty"?

Are you looking for something like nz([myfield], "I'm null"), which would
return either the field value (if there is one) or the string "I'm null" (if
the field is null)?

[jmarr02s]

No, Sorry...What I meant was...The field is empty...

I wish to populate the field with the same literal value (text), such
as "Non-Mobile", but in 1218 individual records...

I can't use the Replace With dialogue box when the field is empty...or
can I?

Thanks!....Hope this is clearer...
jmarr02s
Rick Wannall wrote:

"replace with then the field is empty"?

Are you looking for something like nz([myfield], "I'm null"), which would
return either the field value (if there is one) or the string "I'm null" (if
the field is null)?

[Rick Wannall]

If you want to update an empty field in a table in many records to the same
value, use an update query:

Update [MyTable]
Set [MyField] = "somevalue"
where [MyField] Is Null

Simplest case.