Interchange Column

  • Thread starter Thread starter Duane Hookom
  • Start date Start date
D

Duane Hookom

I would add a new column [TempStorage]. Then create an update query that
updates [TempStorage] with the values from [Age]. Then update the [Age]
field with values from [rno] and the [rno] field with values from
[TempStorage].
If they are both the same data type, you could just rename age to AgeOld,
then rename rno to Age and then AgeOld to rno.

I always make sure I back up the mdb prior to performing procedures like
this.
 
Hi,

i have table like this

myname age rno
-------- ----- -----
xyz 1234 34
abc 2345 35
xyz1 3456 34
abc1 4567 35
xyz1 5678 34

by mistake column values wrongly typed. How to interchange the 'age' and
'rno' columns using SQL.

Thanks in advance.
 
Back
Top