Replacing Blank Data with Text

  • Thread starter Thread starter Gilbert Noetzel
  • Start date Start date
G

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
 
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")
 
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
Click to expand...
Click to expand...
 
Back
Top