assign a value if a field is blank

[monsterman66666]

i would like to assign a value if a field is blank.


thanks

 

[Maquis]

Use an update query with IsNull on the criteria line for the field you wish to update. (By "blank" I assume you mean Null) Maq
<insert witty signature here>

 

[rgbanse]

Marquis,
Another option in query, form or report is NZ
Only works if field is truly null
syntax NZ([FieldName],(ValueThatYouWant))
ie: if the field is truly null Nz([FieldName],0)
will set field to 0
RGB

 

[rgbanse]

Marquis,
Sorry for the misdirect. I meant to send the response to MonsterMan. Hope no criticism was inferred.
RGB

 

[Maquis]

No offense taken here. You're right, the NZ function is another solution. Just depends on what Monsterman is trying to accomplish.

Maq
<insert witty signature here>

 

[sera]

Well I was here looking at this post, and I used the IsNull option that Maquis posted. There is a slight error that took me a few seconds to resolve:

Instead of putting IsNull in the criteria you need to put
Is Null. There needs to be a space between Is and Null.

Hey but thanks guys!
Sera
I often believe that...
My computer is possessed!