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