Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

5 duplicate records each 1 unique field converted into 1 record?

Status
Not open for further replies.

marlin123

IS-IT--Management
May 2, 2000
4
NZ
I have a database of 10,000. some people occur 5 times in the database with five different product codes. like the following:-
John Smith 23 Smith St, Smithville. bb1
John Smith 23 Smith St, Smithville. bk1
John Smith 23 Smith St, Smithville. hu1
John Smith 23 Smith St, Smithville. hu2
John Smith 23 Smith St, Smithville. pl1

What I want to do is get the database to look at the first field and if it has already occured then duplicate the code field at the end of the previous occurrance of the record. Therefore increasing that record by one field. Or even just adding that code into a code field.
Then I end up with onrecord like the below.
John Smith 23 Smith St, Smithville. BB1 Bk1 Hu1 Hu2 Pl1
Please help me if you can!!! [sig][/sig]
 
What does the code refer to?
I think a related table is what you are talking about.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top