replace blank with AA

[Bunce]

I want to replace a blank field in a table with letters AA. If the table has something in the name field, then return that field, if blank, then return AA. I've only written queries in design view. So I've tried something like IIF([tbl1]![name]="","AA",[tbl1]![name]). I guess Access doesn't recognize "" as blank. Any ideas?

 

[MSAccessRookie]

You are on the right track. Try IIf([tbl1]![name] Is NULL,"AA",[tbl1]![name]).

 

[SOS]

"" is an EMPTY String, not blank.

IsNull would be what you would test for but I would capture both an empty string and null by using:

IIF(Len([tbl1]![name] & "") = 0,"AA",[tbl1]![name])

 

[Bunce]

It worked. Thanks so much.

 

[SOS]

Glad to hear.