Results 1 to 6 of 6

Thread: Distinct Records

  1. #1

    Thread Starter
    Member
    Join Date
    Apr 2016
    Posts
    46

    Distinct Records

    Hi

    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.

    Is there any other better & fastest way.

    Thanks

  2. #2
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,123

    Re: Distinct Records

    Why not use DISTINCT in your query?
    Regards,


    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system

  3. #3
    PowerPoster SamOscarBrown's Avatar
    Join Date
    Aug 2012
    Location
    NC, USA
    Posts
    9,143

    Re: Distinct Records

    you have been told how to do this SEVERAL times in other posts...please don't keep asking the same question. |

    PS--the example I posted uses DISTINCT with an MS Access Database
    Sam I am (as well as Confused at times).

  4. #4
    PowerPoster
    Join Date
    Jun 2013
    Posts
    7,219

    Re: Distinct Records

    Quote Originally Posted by SamOscarBrown View Post
    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)...

    Olaf

  5. #5
    PowerPoster SamOscarBrown's Avatar
    Join Date
    Aug 2012
    Location
    NC, USA
    Posts
    9,143

    Re: Distinct Records

    Ahhh....probably, Olaf...I'll go back and look.
    Sam I am (as well as Confused at times).

  6. #6
    PowerPoster SamOscarBrown's Avatar
    Join Date
    Aug 2012
    Location
    NC, USA
    Posts
    9,143

    Re: Distinct Records

    Yup...you're correct, Olaf...here's a small project which displays data (obtained using distinct) as well as putting it into an array.
    Attached Files Attached Files
    Sam I am (as well as Confused at times).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width