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?