brain fart

[jsaltzman]

i want to specify a field "emailsubject" to always have this looked up text.

"Regarding your order # " and ordernumber and "with BookWormAnnex"

i set the field to text with a calculated value and i just get is 0 as the result

i have the result set to text....

if i remove the and all i get as the result is the order number.

[-Queue-]

What does your calculation look like?

[jsaltzman]

never mind i got it thanks. i was supposed to put

"text" & field & "text"

[-Queue-]

& is the concatenation operator. 'And' is a logical operator. You're receiving a zero because you have three operands that can not be interpreted logically.