combine fields

[brino]

i am trying to combine 2 text fields into the one field in a query.
eg. "barry" & "allen" into another field so that it is "barry allen"
how can i do this , ive tried a number of ways but cant solve it ???
or i could use a combo box to transfer the 2 fields into one in a
table ..... i dont know ?

thanks

[pietlinden@hotmail.com]

Re: combine fields

select firstname & " " & lastname as fullname
from sometable;

[brino]

Re: combine fields

thanks heaps that is brilliant !!!!!

pietlinden@hotm ail.com wrote:

select firstname & " " & lastname as fullname
from sometable;