updating table contents

  • Thread starter Thread starter mikemalin
  • Start date Start date
M

mikemalin

Let's say I have a table that has two columns: UID and Description.
For example:

UID Description
1 Alpha
2 Beta
3 Gamma

Now let's say I want to change it a little to something like:

UID Description
1 Alpha
2 Beta
3 Delta
4 Gamma

Is there any code I could run to achieve this? One thought, although
I'm not sure if this would work, would be to find UID 3 in the table
and change it to 4 then add the new "3-Delta" item to the table.

Any help is appreciated.

TIA.
Mike
 
Let's say I have a table that has two columns: UID and Description.
For example:

UID Description
1 Alpha
2 Beta
3 Gamma

Now let's say I want to change it a little to something like:

UID Description
1 Alpha
2 Beta
3 Delta
4 Gamma

Is there any code I could run to achieve this? One thought, although
I'm not sure if this would work, would be to find UID 3 in the table
and change it to 4 then add the new "3-Delta" item to the table.

Any help is appreciated.

TIA.
Mike
Click to expand...
 
Back
Top