J
Jed
I have a simple query, but I seem to be having some trouble. My table
consists of over 100,000 records. Each record has a DL field, and I want to
update these records to have another field called DL4 which takes the DL
field truncates it down and inserts those last 4 into the DL4 field. I tried
to run an append query then update the field, but when I do that all it does
is double the number of records in my table. I'm thinking there is something
I'm leaving out. Any help would be great.
Thanks
consists of over 100,000 records. Each record has a DL field, and I want to
update these records to have another field called DL4 which takes the DL
field truncates it down and inserts those last 4 into the DL4 field. I tried
to run an append query then update the field, but when I do that all it does
is double the number of records in my table. I'm thinking there is something
I'm leaving out. Any help would be great.
Thanks