sql - How can i concatenate two fields in a MS Access 2007 Table and display in a third field? -

enter image description here

i want concatenate 'first name' , 'last name' , display 'customer name' field.

i using ms access 2007.

i explored on this, got know can write vb script below on customer name column name itself:

customer name: [first name]& " " &[last name]

but gives error

in ms access 2013, there option of 'calculated field' easily. not sure how in 2007.

please suggest.

-write query return fields table

-use customer name: [first name]& " " &[last name] formula

-use query instead fo table source further manipulations

O9