## conditional expression

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

Guest

I wrote the following IIF statemeent: url: IIf(IsNull([domainname]),[link] &
[foldername],[domainname])

domainname is a text field with http://www.something.com
link simply shows http://www.graphicfreak.com/
foldername is a text field

Basically, I am making a report that shows a domain name if there is one. If
not, it shows a url and that url is a combination of the link and the
foldername text field.

The results however display a domain perfectly, but the url come out with ##
in it like http://www.graphicfreak.com/##wilton

Two questions.

How can I get rid of the ##?
It would be more efficient if I didn't pull in link from a table and just
CONCATENATE the text. How can I do that?
 
Justine said:
I wrote the following IIF statemeent: url: IIf(IsNull([domainname]),[link] &
[foldername],[domainname])

domainname is a text field with http://www.something.com
link simply shows http://www.graphicfreak.com/
foldername is a text field

Basically, I am making a report that shows a domain name if there is one. If
not, it shows a url and that url is a combination of the link and the
foldername text field.

The results however display a domain perfectly, but the url come out with ##
in it like http://www.graphicfreak.com/##wilton

Two questions.

How can I get rid of the ##?
It would be more efficient if I didn't pull in link from a table and just
CONCATENATE the text. How can I do that?
Click to expand...


You really lost me there, but it seems that link is just a
text string. If so, then enclose it in quotes so you can
concatenate it:

url: IIf(domainname Is Null), "http://www.graphicfreak.com/"
& foldername, domainname)
 
Back
Top