How can I dived ! field into 2?

[Guest]

Subject: How do I combine the contents of two fields into one in access?

 

[Guest]

I send this message before I had finnished writing it. So I send another one
which is the right one. Sorry about this mistake.

 

[=?iso-8859-1?Q?J=F6rg_Ackermann?=]

Subject: How do I combine the contents of two fields into one in
access?

In query:

NewField: [Field1] & " " & [Field2]

Acki

 

[Guest]

NewFieldName: ([Field1]) & ([Field2])

or

NewFieldName: ([Field1]) & " " & ([Field2])

The second option simply puts a space between both fields.

-Tony