July 8, 200421 yr 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
July 8, 200421 yr 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
July 9, 200421 yr 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
Create an account or sign in to comment