Using "&" function like excel?

[romanticode]

I have excel linked table. How can i add one column that cointains combinaton data of 2 column.

Examp:
Cell A1 = guest
Cell B1 = House

I want place on C1 = GuestHouse

On excel i can use "A1"&"B1" function. But i don't know how to do it on access?

 

[Ranman256]

its the same, only use fieldnames, or textbox names:
= field1 & field2

 

[romanticode]

its the same, only use fieldnames, or textbox names:
= field1 & field2

i've tried the code, but not working on table or query.
where's exactly i should place the code?

 

[ypma]

As Ranman typed . In your query add a new field for example FullName.

Fullname :[Guest] & "," & [House]

I have added the comma , but that is optional .

You did not mention a form so have provided solution for a query

Regards Ypma

 

[Ranman256]

In a query field.

 

[romanticode]

As Ranman typed . In your query add a new field for example FullName.

Fullname :[Guest] & "," & [House]

I have added the comma , but that is optional .

You did not mention a form so have provided solution for a query

Regards Ypma

I've solved the problem. I use "+" instead of "&".
Thanks All.