Trap 1 of each entry

[ninash]

Hi All,
I have a table that contains address information.
The address information has a country field which repeatedly contains duplicate information eg. many address's in Portugal, Spain and others

I need to be able to trap one of each country to leave me with a list for all countries in that table without any duplicates.

Is there anyone that can help me with this problem?

Regards
Tony

 

[KenReay]

Hi

Somethink like:

SELECT Country FROM tblAddress GROUP BY Country; Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[ninash]

Thanks Ken

Don't you just hate it when you know the answer already and you just need to be clipped around the ear to make you feel stupid.

Again thank you very much for your quick reply

Tony

 

[KenReay]

Hi

Yes, know that feeling Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK