Replace all the duplicate data with NIULL in column except one row.
Database
1
Posts
1
Posters
0
Views
1
Watching
-
I have table in access with duplicate rows like: Table: T1. c1---c2 ------ 1---A 1---B 1---C 2---D 2---E 3---F 3---G So now i want to replace all the duplicate data with NIULL in column c1 except one row, something like: Table: T1. c1---c2 ------ 1---A NULL---B NULL---C 2---D NULL---E 3---F NULL---G What will be the best way to do that in MS access database? Could you guys please help me on that.
Regards, Md. Marufuzzaman