2 formulas in a text box

[BlackJack17]

Hello,

In a report that I've created, I have a text box which I would like to show multiple elements in the same box to be sure that the spacing is just right. The 2 formulas that I'm trying to put in one box are:

=[SGL] & ", " & [Fed] & ", " & [Borr Src] & ", " & [Avail Tm]
and
=IIf([Action Requested]="Deleted","from","to")

in that order. I tried putting the IIf on the end of the first formula, but that didn't do the trick. Any thoughts on how to put it into the text box criteria field?

Thanks so much,

Chuck

[missinglinq]

I'm not exactly clear on what you're trying to do, but you can't put two forulas in a textbox! I think maybe what you want is

=[SGL] & ", " & [Fed] & ", " & [Borr Src] & ", " & [Avail Tm] & IIf([Action Requested]="Deleted","from","to")

Linq ;0)>