copying table data within same table (1 Viewer)

mike wild

Registered User.
Local time
Today, 04:51
Joined
Feb 16, 2003
Messages
69
I have a table called "list"

The field "sendto" contains time data.

I am trying to copy all the data in the "sendto" field to a nother field called "omit12"
Both fields are in the same table - can this be done

so far i have
DoCmd.RunSQL "INSERT INTO list SELECT
  • .sendto FROM list;"
 

Tim K.

Registered User.
Local time
Today, 04:51
Joined
Aug 1, 2002
Messages
242
You can use an Update query to help this out.

UPDATE list SET omit12 = sendto;

But why do you want to duplicate this? It's not recommended to store repeated info in both fields.

:)
 

mike wild

Registered User.
Local time
Today, 04:51
Joined
Feb 16, 2003
Messages
69
Tim K. said:
You can use an Update query to help this out.

UPDATE list SET omit12 = sendto;

But why do you want to duplicate this? It's not recommended to store repeated info in both fields.

:)

Because sendto is a text field that gets stripped with a "Iff" CLAUSE, AND HAS IT'S BRACKETS DELTED.

Then after Copy the data to omit12, all the info is deleted from sendto.
And i'm left with time data in a time formatted field.
 

Users who are viewing this thread

Top Bottom