Can access query do this??

[naobao]

Can change the table record from "Part1" to "Part2" use access query??

Part1
GOLD-023-B-126
YELLOW-23-A76-12
GREEN-7-NW-6B

Part2
GOLD023B126
YELLOW23A7612
GREEN7NW6B

 

[sneuberg]

If Part1 is a field let's say PartName for example and then something like:

UPDATE TheNameOfTheTable SET PartName = 'Part2' WHERE PartName = 'Part1';

Do you want to remove the hyphen too?

 

[naobao]

Part1 is table records
Part2 is query result
I want to use a query to remove hyphen

 

[sneuberg]

In that case

UPDATE Table1 SET Table1.PartName = Replace([Table1]![PartName],"-","");

This is demonstrated in the attached database.

 

[naobao]

Many thanks for help!!