Subject: How do I combine the contents of two fields into one in access?
K Kristjan May 20, 2005 #2 I send this message before I had finnished writing it. So I send another one which is the right one. Sorry about this mistake.
I send this message before I had finnished writing it. So I send another one which is the right one. Sorry about this mistake.
J Jörg Ackermann May 20, 2005 #3 Kristjan said: Subject: How do I combine the contents of two fields into one in access? Click to expand... In query: NewField: [Field1] & " " & [Field2] Acki
Kristjan said: Subject: How do I combine the contents of two fields into one in access? Click to expand... In query: NewField: [Field1] & " " & [Field2] Acki
T Tony May 20, 2005 #4 NewFieldName: ([Field1]) & ([Field2]) or NewFieldName: ([Field1]) & " " & ([Field2]) The second option simply puts a space between both fields. -Tony
NewFieldName: ([Field1]) & ([Field2]) or NewFieldName: ([Field1]) & " " & ([Field2]) The second option simply puts a space between both fields. -Tony
