By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,482 Members | 2,107 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,482 IT Pros & Developers. It's quick & easy.

Replace with - when data field is empty

P: n/a
Hi,
How do I replace with when the field is empty?
Thanks!
jmarr02s

Jun 7 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"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)?
Jun 7 '06 #2

P: n/a
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)?


Jun 7 '06 #3

P: n/a
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.
Jun 7 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.