I am using MS-Access . I have 1 recordset which multiple records. From this records a particular field has duplicate records
I want only distinct records. Is it possible to query recordset again
1 way is i loop thru recordset. But then i have to reset it to .movefirst.
PS--the example I posted uses DISTINCT with an MS Access Database
I didn't find any example of yours (in the other thread) ... only two screenshots you've posted there...
(perhaps that's what contributed to the confusion of the OP)...