I have an access DB with two name fields, first and last, that I want
to move into one field with the format "last, first". All the fields
are within the same record and the table is about 20K records in size.
How??

Thanks.
J

Sounds like a job for MACRO-Man - DuhDuhDuhDuhDaDaaaah! Up Up andawaaaayy!!

"Jeff" <mickmaster69 (AT) hotmail (DOT) com> wrote

mickmaster69 (AT) hotmail (DOT) com (Jeff) wrote in message news:<b254d600.0309120942.5f5f34d0 (AT) posting (DOT) google.com>...
Hello Jeff.

May I suggest two ways?
1. You can concantinate the data into one field in your
source query, as an expression, to display in your
inputting form if your using one.
Exampe: FullName: [LName] & ", " & [FName]
Then add this new field to your form to display it.

2. Create an update query with the FullName field in
your source table. Use the source table in your query
and add the FullName field. Make sure it's an update
query type, and add the above statement into the
"Update To" row for that field.
Example: [LName] & ", " & [FName]
Then run the query. It will put the data into your
field accordingly.

Regards,

Ray