If field is blank add value?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Str8 - 29 Sep 2006 17:18 GMT

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.

Reply to this Message

Klatuu - 29 Sep 2006 17:49 GMT

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])

> 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.

Reply to this Message

Str8 - 29 Sep 2006 19:54 GMT

Thanks I'll give it a try I have that database locked up right now.

Thanks again

> 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
[quoted text clipped - 8 lines]
> >
> > Thanks in advance.

Reply to this Message