How I can extract a list from another one??

  • Thread starter Thread starter Guest
  • Start date Start date
G

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 ?????
 
SELECT DISTINCT myvalue FROM tblMyTable ORDER BY myvalue

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