Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2009
    Posts
    7

    Unanswered: MS Access simple query has repeating records

    Hi All,

    I'm testing things out here and ran into a rather odd problem.

    When I run a simple query, the first record shows up once, the second record shows up twice, the third record shows up three times... well you see the pattern here.

    Anybody seen this before?

    Please make it stop!
    Derek

  2. #2
    Join Date
    May 2009
    Posts
    508
    Provided Answers: 1
    Derek, If you could post your query, it would help to see what you are doing.

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Wow!! Nice job! I'd have no idea how to get a query to do that!!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Jan 2009
    Posts
    7
    All I did was use the Query Wizard (Simple).

    Derek

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    ...and the sql you are using is
    I'm betting you haven't properly defined the relationships or there is anohter issue to do with the join/where clause

    to show the sql.....
    open the query designer
    select the sql view.... (its usually the second row of buttons, far left of menu bar).
    copy and paste the sql here and I reckon some of the SQL know it all's will be able to help pretty quickly
    I'd rather be riding on the Tiger 800 or the Norton

  6. #6
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Do ALL the fields for the specific duplicated records in the query have the same values for EVERY record which is duplicated?

    Have you tried editing the properties of the query and setting the Unique Records property to Yes? (and removing any fields which would cause the record to show twice - ie. John Jone's duplicated records have different values for Field X.)

    There's many reasons records would be duplicated. If you post your SQL statement it will help show why.
    Last edited by pkstormy; 05-30-09 at 00:36.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  7. #7
    Join Date
    Mar 2012
    Posts
    1

    need help

    Hello all,

    I'm basheer, creating a database for cash payment. I created a query which shows repeated value.

    I created a query with two different fields, from each field there is a payment date and sum of payment.

    when I left joint 2 tables on customer name, I see there are some values repeated. for reference please review the attachment.

    I want the repeated values to show only one time.

    Please help me if any one can resolve this problem....
    Attached Files Attached Files

Posting Permissions

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