Replacing Blank Data with Text

[Gilbert Noetzel]

People -

I am having a mental block..and I need your help. Does the below
'expression' will work when you have the following data field:

Data Field = Country

Blank = United States
Non-Blanks = 'listed countries'

I wrote this expression and all the data in the column 'country' comes
out blank:

Country: IIf([CMCTRY]=" ","United States")

Above did not work..why?

Gil

 

[MH]

Country: IIf(IsNull([CMCTRY]),"United States","Listed Countries")

MH

 

[Guest]

Generally, one blank (or, space(1)) doesn't occur in tables because
everything is trimmed. Try
Country: IIf([CMCTRY]="","United States","Im something else")
or, Country: IIf(IsNull([CMCTRY]),"United States","Im something else")

 

[Gilbert Noetzel]

both of you are correct..on the Country: IIf(IsNull(.....

Why am I so backwards!

thank you ...and have a great weekend.

gil

Generally, one blank (or, space(1)) doesn't occur in tables because
everything is trimmed. Try
Country: IIf([CMCTRY]="","United States","Im something else")
or, Country: IIf(IsNull([CMCTRY]),"United States","Im something else")



:

People -

I am having a mental block..and I need your help. Does the below
'expression' will work when you have the following data field:

Data Field = Country

Blank = United States
Non-Blanks = 'listed countries'

I wrote this expression and all the data in the column 'country' comes
out blank:

Country: IIf([CMCTRY]=" ","United States")

Above did not work..why?

Gil