how do I add last name and first name

[jsanbor1]

fields together to make a "last, first" view in Access?

 

[Ammodog]

You can Export the Table in a text file. Seperate it by coma. and it will bring the two fields together.

Christopher Abney
"There is no limit to the good you can do if you dont care who gets the credit"
[Afro2]

 

[r937]

select trim(last) + ', ' + trim(first) as lastfirst

save it as a query

(a saved query in access functions like a view)


rudy

http://r937.com/

 

[jsanbor1]

thanks for the reply Christopher.

can it be done with a query?

 

[jsanbor1]

thanks!