Merge two alphanumeric fields into new field in a query

[Tony Dungate]

I want to perform a query that merges two alphanumeric
into one, such as firstname,space,lastname

 

[Phobos]

SELECT [Field1] & " " & [Field2] as MyNewField
FROM MyTable;

P

 

[Rick Brandt]

I want to perform a query that merges two alphanumeric
into one, such as firstname,space,lastname

Add a new field to query based on an expression...

FulName: [firstname] & " " & [lastname]