adding spaces in a calculation

[Adam123]

what I want to do is make a calculation taking 3 fields, and puting them into 1 field adding a space inbetween each field being added

[-Queue-]

field1 & " " & field2 & " " & field3

[Neverland]

Adam123 -

Very easy...

Your calculation would look something like:

Field1 & " " & Field2 & " " & Field3

The quotes are literal text and in this case just put a space (or anything else) between them. The "and" symbol concatenates (combines) things together.

Have fun!

SR

[Adam123]

Thanks! I tried something like that but it didnt like it, ill try agian

[aklodner]

Sorry to be late to this conversation. One more thing to add, make sure your calculation result is set to return as text. Otherwise, you could have problems.

A