duplicate rows

[RFarrington]

i have a spreadsheet that i imported into access. I needed to do this because of the number of columns in this spreadsheet. The first column is ticket numbers, the rest of the columns will be different data for each ticket. i would like to remove any duplicate rows that contain the same ticket number. any help would be appreciated.

 

[alansidman]

I think this video will solve your issue.

http://www.datapigtechnologies.com/flashfiles/duplicateproblem.html

Alan