COPY RECORD

[Guest]

I hv this field in my table

IC
123
456
789

How to copy this field & record in new field (say IC2) in the same table.

TQ

 

[John W. Vinson]

I hv this field in my table

IC
123
456
789

How to copy this field & record in new field (say IC2) in the same table.

TQ

Two questions:

What do you mean by "copy this field & record"? You have THREE records. Do you
want a table with six records, or a table with a second field identical to
this field?

And... if the latter... WHY? What's the point of storing the same information
redundantly?

John W. Vinson [MVP]

 

[Guest]

Two questions:

What do you mean by "copy this field & record"? You have THREE records. Do you
want a table with six records, or a table with a second field identical to
this field?

And... if the latter... WHY? What's the point of storing the same information
redundantly?

John W. Vinson [MVP]

What i want is to duplicate the field with new field. Reason being is i dont
want to change the original data in the first field as i import the data form
another system.
Secondly i can change or update or partial delete records in the new field
without having to change the data in the first field.

FYI i'm using Access for query & reporting purpose where the data are
imported from another system.

Hope this suffice

TQ

 

[John W. Vinson]

What i want is to duplicate the field with new field. Reason being is i dont
want to change the original data in the first field as i import the data form
another system.
Secondly i can change or update or partial delete records in the new field
without having to change the data in the first field.

FYI i'm using Access for query & reporting purpose where the data are
imported from another system.

Well, you can't import a *field* from another system - only an entire record.

And you can't "partial delete" a record: you can keep the record, or you can
delete it. There's no "partial". What you can do is *edit* a record, perhaps
by changing the value of a field from some text to NULL - but the record
still exists in its entirity, it just has a different (null) value in one
field.

I would suggest that you import the table, to a "master" table; and then run
an Append query copying the data in the table to a second, "working" table.
This will let you keep the data in its original form and have a second copy
which can be edited.

John W. Vinson [MVP]