I have a table called ImpJobID which has been records imported from an Excel spreadsheet. It contains two fields called JobID & Description. When the table is imported from Excel, one JobID can appear multiple times in the ImpJobID table.
I would like to remove the duplicates using VBA & create a new table only containing one record for each JobID. So, if a JobID is in the ImpJobID table 5 times, I only want to show it once in the new table. Likewise, if a JobID is in the ImpJobID table once, then it should appear once in the new table.
I'm not sure how to go about this. Can anyone make a suggestion?
I would like to remove the duplicates using VBA & create a new table only containing one record for each JobID. So, if a JobID is in the ImpJobID table 5 times, I only want to show it once in the new table. Likewise, if a JobID is in the ImpJobID table once, then it should appear once in the new table.
I'm not sure how to go about this. Can anyone make a suggestion?