Duplicate records

  • Thread starter Michael Humphreys
  • Start date
M

Michael Humphreys

I have a spreadsheet with a list of postcodes and i wish
to exclude all the duplicate codes.
How can I do this? Your help would be appreciated!

Many thanks

Michael
 
M

Michel Walsh

Hi,

SELECT DISTINCT postCode FROM theTableNameHere


would do.


Hoping it may help,
Vanderghast, Access MVP
 
Top