Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jan 2012
    Posts
    155
    Thanks
    118
    Thanked 0 Times in 0 Posts

    Access 2007 - records are repeating

    friends,

    I have several related tables. I made a query but the records are repeating. as I do not to repeat these records?

    Any help is welcome.

  2. #2
    Administrator
    Join Date
    Jun 2010
    Location
    Portugal
    Posts
    12,519
    Thanks
    152
    Thanked 1,398 Times in 1,221 Posts
    Hi Fabio,

    Open the query in SQL View and add DISTINCT after the SELECT, as in:

    SELECT DISTINCT CampoA, CampoB,...

  3. The Following User Says Thank You to ruirib For This Useful Post:

    fabiobarreto10 (2012-12-06)

  4. #3
    Administrator
    Join Date
    Jun 2010
    Location
    Portugal
    Posts
    12,519
    Thanks
    152
    Thanked 1,398 Times in 1,221 Posts
    Glad it worked, Fabio .







    P.S.: The server is warping time again...

  5. The Following User Says Thank You to ruirib For This Useful Post:

    fabiobarreto10 (2012-12-06)

  6. #4
    2 Star Lounger
    Join Date
    Jan 2012
    Posts
    155
    Thanks
    118
    Thanked 0 Times in 0 Posts
    Dear Rui, thanks for replying and helping. Using the "DISTINCT" worked perfectly.

    Thank you.

Posting Permissions

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