By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,392 Members | 1,561 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,392 IT Pros & Developers. It's quick & easy.

2 formulas in a text box

P: 14

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]
=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,

Dec 19 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 3,532
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

Expand|Select|Wrap|Line Numbers
  1. =[SGL] & ", " & [Fed] & ", " & [Borr Src] & ", " & [Avail Tm] & IIf([Action Requested]="Deleted","from","to")
Linq ;0)>
Dec 19 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.