If field is blank add value?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I assume this is easy but can't figure it out. I know how to use iff
statments to return one value or another but here's what I need. Basically if
a field in a column comes back blank I want "No lvl" to get put in that blank
field.

Thanks in advance.
 
If you mean in a select query, you can do it with a calculated field and and
IIf statement. In the query builder Field row, make up a name and put a
calculation in it. For example purposes, we will call the table field
[The_Level]
Level: Iif([The_Level] Is Null, "No lvl", [The_Level])
 
Thanks I'll give it a try I have that database locked up right now.

Thanks again

Klatuu said:
If you mean in a select query, you can do it with a calculated field and and
IIf statement. In the query builder Field row, make up a name and put a
calculation in it. For example purposes, we will call the table field
[The_Level]
Level: Iif([The_Level] Is Null, "No lvl", [The_Level])

Str8 said:
I assume this is easy but can't figure it out. I know how to use iff
statments to return one value or another but here's what I need. Basically if
a field in a column comes back blank I want "No lvl" to get put in that blank
field.

Thanks in advance.
Click to expand...
Click to expand...
 
Back
Top