Update Query

[jj1]

I have a table with 7000 records and I want to update 80 records say Name field with the concatenated name field name now. How can I design that query.

[orange]

You would start with the name of the table involved and the field whose value you want to update.
To isolate 80 records from 7000 will require specific criteria (WHERE clause).
Name is a reserved word in Access and would require enclosing in [ and ] to avoid error.
What exactly is a concatenated name field?

You may find more info here.

[June7]

Do not use reserved words as field names. It will bite you some day. It did me this week (a field I did not create and have no control over).

Why would you want to update a table with concatenated data? Just use query with calculated fields.