UPDATE records by copying from same table?
in [Queries]
|
From: Billp on 17 May 2010 17:56 Hi, I have a table with new records added, that is some information has been pre-filled. Say I have 3 new records with the same reference code ZZZZZZ - they all have unique auto numbered lines. Say for example ID Cust_ID FirstName LastName .............. 1234 ZZZZZZ Fred Jones ........ 1235 ZZZZZZ Bruce Watts ......... 1236 ZZZZZZ Ted Nugent .......... Now sitting at the start of the table is 1 AAAAAA Fred Jones Blue Green Orange.... etc 2 AAAAAA Bruce Watts RED Violet Green....etc 3 AAAAAA Ted Nugent Red Green Purple... etc How do I if it is possible Update the New Records with the added information, copy for each old record back into the new record. The Cust_ID's are different , the only two feilds that are common is the Firstname and The lastName. This table is a sub table of a sub table. The extra info cannot be directly inserted as the new records are created. Or if not easy would VBA be another option. Thankyou in advabce Regards Bill
From: Jerry Whittle on 19 May 2010 10:53 >> 3 AAAAAA Ted Nugent Red Green Purple... etc >>1236 ZZZZZZ Ted Nugent .......... The problem is that you shouldn't (1) be putting similar data in different columns like Red Green Purple and (1) if Ted is always Red Green Purple, then you shouldn't be putting this data in each record. Instead you should have another table about the individuals with this data. Besides Sammy Hagar is the Red Rocker - not Ted Nugent! -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Billp" wrote: > Hi, > > I have a table with new records added, that is some information has been > pre-filled. > > Say I have 3 new records with the same reference code ZZZZZZ - they all have > unique auto numbered lines. Say for example > > ID Cust_ID FirstName LastName .............. > > 1234 ZZZZZZ Fred Jones ........ > 1235 ZZZZZZ Bruce Watts ......... > 1236 ZZZZZZ Ted Nugent .......... > > Now sitting at the start of the table is > > 1 AAAAAA Fred Jones Blue Green Orange.... etc > 2 AAAAAA Bruce Watts RED Violet Green....etc > 3 AAAAAA Ted Nugent Red Green Purple... etc > > > How do I if it is possible > Update the New Records with the added information, copy for each old record > back into the new record. The Cust_ID's are different , the only two feilds > that are common is the Firstname and The lastName. > > This table is a sub table of a sub table. The extra info cannot be directly > inserted as the new records are created. > Or if not easy would VBA be another option. > > Thankyou in advabce > Regards > Bill
|
Pages: 1 Prev: Convert text to Combo Next: Multiple table query displays only one record |