Query using =iif(isnull plus a comma and 1

[Tiggertoo]

This is what I have
IT: ([ITOwn1] & ", " & [itown2] & ", " & [itown3])
Unfortunately if a field is null you end up with a comma or two ,,Joe Smith

I'm hoping to write something like
IT:=iif(isnull(([itown1]),"",([itown1]&", ")(isnull(([itown2]),"",([itown2]&", ") etc

In other words if itown1 is null then print nothing else print itown1, (that's with a comma) and then continue on with if itown2 is null then print nothing else print itown2,

Ending up with John Smith, Joe Doe, Joe Smith instead of
,,Joe Smith.

Hope I've made sense...

Or is there an easier way to accomplish this... remember I don't speak VB

 

[PHV]

IT: ([ITOwn1] + ", " & [itown2] + ", " & [itown3])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Tiggertoo]

Wow! so easy and it does work. Perfect

 

[traycee]

Thanks,
Just exactly what I was looking for.

 

[Tiggertoo]

Isn't this the most helpful site!