access
 

how can i combine two fields into one field in access 2007?
EX: firstname and lastname when i do the combine order it should appear like
this
lastname, a comma, a space, and then the first name

access
 

Shouldn't you be asking that in an Access group? In Excel you would have a
formula like:

=B1 & ", " & A1

assuming first name in A1 and last name in B1.

Hope this helps,

Pete

"NA" wrote in message
...
how can i combine two fields into one field in access 2007?
EX: firstname and lastname when i do the combine order it should appear
like
this
lastname, a comma, a space, and then the first name

access
 

Create a query. Using the Expression Builder, crate a new field something
like...
Expr1: [MyLastNameField] & ", " & [MyFirstNameField]
where 'Expr1' is the field name.
--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown


"NA" wrote:

how can i combine two fields into one field in access 2007?
EX: firstname and lastname when i do the combine order it should appear like
this
lastname, a comma, a space, and then the first name