I am trying to use a query from VB to an access database and select the distinct records. I find it impossible to believe that access does not have a distinct function but apparently it does not.
does anyone know how I can get a query like this to work? "select distinct(id) from tablename"
any help is appreaciated.