Modify table based on ID

Hi,

I have a table that I import from another access database. It has field in
it that include Name, ID, Weekly Target etc. That is a person in the table
that appears twice but has two different IDs. For instance, the person's
name is Joe Smith who has an ID of JS1 and JS2. What I want to do is to
write a Query that modifies this table and has The name of Joe Smith with the
ID of JS2 changed to Joe Smith - Retail. The other Joe Smith can remain the
same. The following week I will import the table again and then run some
type of append query that will make this change once again. Can anyone help
with this?

Thanks,
--
Chuck W

For your name field use this and modify to fit your field names --
NameCheck: Iif([ID]="JS2" and [Name]="Joe Smith", "Joe Smith - Retail",[Name])

"ChuckW" wrote:

Hi,

I have a table that I import from another access database. It has field in
it that include Name, ID, Weekly Target etc. That is a person in the table
that appears twice but has two different IDs. For instance, the person's
name is Joe Smith who has an ID of JS1 and JS2. What I want to do is to
write a Query that modifies this table and has The name of Joe Smith with the
ID of JS2 changed to Joe Smith - Retail. The other Joe Smith can remain the
same. The following week I will import the table again and then run some
type of append query that will make this change once again. Can anyone help
with this?

Thanks,
--
Chuck W