This is probably pretty simple, but I am very new to Access. I have created a table and there are duplicate account numbers in the first column of the table. How do you remove the duplicates from the table?? Is there are query I can use?

Any assistance would be appreciated!

Shawn.

I wouldn't do this from VBA, though it can be done. I would look at using the query wizard. One of the options is a "Remove Duplicates" or something like that.