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]
