SQL Workaround?

[gers0667]

I'm syncing an Access Database via Active Sync and using eVB to access it. I want to do a SELECT DISTINCT x FROM x, which is valid in Access, but I get errors running it on the PocketPC. Can anyone think of a work around for this one??

[gers0667]

I got around the problem by sorting the list and then did a comparison:
Last = ""

Do While Not oRecordset.EOF
Current = oRecordset.Fields("Type")
If Current <> Last Then
Last = Current
lstType.AddItem Current
End If
oRecordset.MoveNext
Loop