Results 1 to 4 of 4
  1. #1
    Thompyt is offline Expert
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2014
    Location
    El Paso, TX
    Posts
    862

    Duplicates appearing

    Why do I get duplicates for "ZIBFC32 (TO'd frm FA BN)" in qryRadios?

    If I look at data, there are 4 Rows where [Row Type] are 3 that = "MEQUIP" and 1 = "DISMEQUIP"

    When I rune rptMtdRadios I get 6 Lines where there should be 3, thus ea line is duplicated.

    Please do not comment on the naming conventions. The table named data is an imported Excel not developed by me.

    Test.zip

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,549
    some queries will produce 'duplicates' depending on the joins and/or the fields in the query.

    you can set the query property UNIQUE RECORDS = TRUE, to not see them.

  3. #3
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    You get 6 records in query because there are two T37588 in tbllcons and 3 in Data associated with "ZIBFC32 (TO'd frm FA BN)" -- 2 times 3 = 6. Without the filter criteria there would be 10 records in query for T37588.

    Advise not to use spaces nor punctuation/special characters (underscore only exception) in naming convention.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #4
    Thompyt is offline Expert
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2014
    Location
    El Paso, TX
    Posts
    862
    Thanks June7 and Ranman. The duplicates in the tbleIcon explain a lot. Plus I used Ranmans tip.

    Appreciate it.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Compile Errors Not Appearing
    By MatthewR in forum Programming
    Replies: 18
    Last Post: 11-29-2016, 09:35 AM
  2. Replies: 3
    Last Post: 01-18-2016, 01:55 PM
  3. Data not appearing now in form
    By Waterdog in forum Forms
    Replies: 13
    Last Post: 08-28-2015, 12:57 PM
  4. Query sum is not appearing
    By trident in forum Queries
    Replies: 3
    Last Post: 12-15-2014, 06:23 AM
  5. Replies: 1
    Last Post: 09-05-2012, 01:36 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums