Show Existing Field in IIF function

[Faeyren]

I am trying to combine an IIF Function with an existing field.


Under18: IIf([Child],[18BD],"")
Shows the 18th Birthday correctly, but I can't seem to add "Under 18 until"


Under18: IIf([Child],"Under 18 until" and [18BD],"")
Shows -1




Under18: IIf([Child],"Under 18 until [18BD]","")
Shows Under 18 until [18BD]



How do I make it so that it shows
"Under 18 until 1/1/2018" ?

 

[xenou]

Hi welcome to the board!

The concatenation operator here (also known as the mash operator or squish operator) is the & character, so you should get:

Under18: IIf([Child],"Under 18 until " & [18BD],"")

 

[Faeyren]

oi..... x.x.... Thank you!! That worked!

 

[xenou]

You're welcome!