How I can extract a list from another one??

[Guest]

I have repeated values in a list like:
1
2
2
3
4
4
5
I need a new list with the unrepeated values like 1-2-3-4-5 like extract
command in old lotus 123 ?????

 

[Graham R Seach]

SELECT DISTINCT myvalue FROM tblMyTable ORDER BY myvalue

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia