 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Importing / Linking / March 2007Replacing Blank Data with Text
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 Country: IIf(IsNull([CMCTRY]),"United States","Listed Countries") MH > People - > [quoted text clipped - 14 lines] > > 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 - > [quoted text clipped - 14 lines] > > Gil 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 [quoted text clipped - 19 lines] >> >>Gil |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.