How I can extract a list from another one??

M

M_Amin

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 ?????
 
G

Graham R Seach

SELECT DISTINCT myvalue FROM tblMyTable ORDER BY myvalue

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Top