I have a table that contains a set of areas
ID Text
1 Area1
2 Area2
3 Area3
4 Area4
5 Area5
6 Area6
What I would like to do is alter that table so that area1,2 now become area1, area3 and 4 become area2 and areas 5 and 6 become area 2.
The people who would be doing this do not have much access skills so is there an easy way of doing this. As there are hundreds of areas to change and the link to other tables.
ta
ID Text
1 Area1
2 Area2
3 Area3
4 Area4
5 Area5
6 Area6
What I would like to do is alter that table so that area1,2 now become area1, area3 and 4 become area2 and areas 5 and 6 become area 2.
The people who would be doing this do not have much access skills so is there an easy way of doing this. As there are hundreds of areas to change and the link to other tables.
ta