We help IT Professionals succeed at work.
Get Started

Add sequential number to a column that has duplicate names

Last Modified: 2015-03-30
I am currently working on a database project that involves creating an excel by extracting certain fields from a table in Access by using DAO.recordset.  After doing the process of extracting information and assigning the correct names to some of the records in those fields I have duplicates that will need an sequence number that will identify them depending on some of the criteria from other columns.  If I could get some guidance on how to accomplish this.  right now, this process produces a CSV file, then it imports this CSV in the database, and then exports the file as XLS.  I am hoping that this sequence can be done when the csv is imported into the database and assign the sequence numbers on the names that need it, and then continue to export the xls.  If it's vba I am ok with it and is probably better for me if it's done with vba.

example of desired results
Watch Question
IT Manager
This problem has been solved!
Unlock 3 Answers and 17 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE