Formula in query

  • Thread starter Thread starter jptpjs via AccessMonster.com
  • Start date Start date
J

jptpjs via AccessMonster.com

Hope someone can help.
I have a query with a formula that combines a series of textboxes to form one
result.
There are a series of messages from 6 text boxes on a form I wish to combine
into one paragraph on a report.
The problem I have is that if I only have information in message1 through
message5 and nothing entered in message6 the result returns nothing.
I would like a formula to return whatever is in any of my text boxes.
Below is the formula. Works great if I have 6 messages.


mess: [message1]+" "+[message2] +" "+[message3]+" "+[message4]+" "+
[message5]+" "+[message6]

Thanks
Pete
 
Allen,

Absolutely perfect!

Thanks

Pete

Allen said:
Replace the plus signs with ampersands:
mess: [message1] & " " & [message2] & ...

These 2 concatenation operators are slightly different:
"A" & Null => "A"
"A" + Null => Null

More info on handling nulls:
http://allenbrowne.com/casu-12.html
Hope someone can help.
I have a query with a formula that combines a series of textboxes to form
Click to expand...
[quoted text clipped - 13 lines]
Thanks
Pete
Click to expand...
Click to expand...
 
Back
Top