Duplicate records

  • Thread starter Thread starter Michael Humphreys
  • Start date 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
 
Hi,

SELECT DISTINCT postCode FROM theTableNameHere


would do.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top