• 97 – Query Returns Duplicates

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » 97 – Query Returns Duplicates

    • This topic has 2 replies, 2 voices, and was last updated 24 years ago.
    Author
    Topic
    WSMelanieB
    AskWoody Lounger
    April 6, 2001 at 4:55 pm #354767

    I have a parameter query to pull records for user selected dates (i.e., beginning date and ending date). When I run it, it returns multiple records. For instance, it will return 174 records, but when I click on sort by date, it shows 6 records (the right number). The 174 seems to be many many duplicates. What am I doing wrong?

    Reply | Quote
    Viewing 0 reply threads
    Author
    Replies
    • WSMelanieB
      AskWoody Lounger
      April 6, 2001 at 8:34 pm #521916

      Well, I found the answer. I had copied the query from another query and deleted the fields I didn’t want. However, that left a table in the query that I wasn’t using. When I deleted that table from the query (even though I wasn’t using any of the fields from that table), it worked beautifully. I don’t know SQL, but when I looked at it in SQL view, there was an innerjoin. Whew.

      Reply | Quote
      • WScharlotte
        AskWoody Lounger
        April 7, 2001 at 2:46 am #521944

        You should always remove unused tables from queries. The joins with such a table can easily create multiple instances of a record unless the relationship between that table and the one it’s joined to is one-to-one.

        Reply | Quote
    Viewing 0 reply threads
    Reply To: 97 – Query Returns Duplicates

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    April 2025
    S M T W T F S
     12345
    6789101112
    13141516171819
    20212223242526
    27282930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.