×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

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

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

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

(OP)
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!!!

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

What does the code refer to?
I think a related table is what you are talking about.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close