Concatenate

[Guest_imported]

I have two fields that i need to combine into a new field, i.e.,

Field1 Field2 = Field3
Main St. = Main St.

How can I do this?

Thanks in advance..

 

[gol4]

Use the ampersand

=field1 & field2

you can do this via a query or a form you can't do this using the tables default value

 

[Nevets]

...just a little refinement on the previous response
= [Field1] & [Field2] will result in combining the two as one string without spaces. For example MainSt.
= [Field1] & " " & [Field2] will add a space in between to give you Main St

 

[chillay]

You can do it like this. This will display field2 and field3 with a space separating field1 and field2.

SELECT field2& ' ' &field3
FROM TableName