Results 1 to 6 of 6
  1. #1
    yharris217 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Oct 2017
    Posts
    3

    Finding Duplicates

    Good day! Is there a way to create a query that finds duplicates that meet certain criteria? For example, I have a table that lists products and their promotional pricing. I want to find duplicates, but I want to find current duplicates using the expiration date field. Meaning, I wouldn’t want to see duplicates for anything where the promo has expired. Only current data. I’ve tried Googling but can’t find anything the helps me.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    make a base query, to exclude expired and other critiera.
    then use the query wizard and make a FIND DUPLICATE query, on the above query.

  3. #3
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    There is a Wizard that can help you with that.
    See: https://support.office.com/en-us/art...3-6b23c7d60fbb

    To add Criteria to it, once it is finished, just change to Design View, add your Expiration Field, change the "Total" row value under this field from "Group By" to "Where", then add your Criteria on the Criteria row.

  4. #4
    yharris217 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Oct 2017
    Posts
    3
    Awesome. Thank you both!

  5. #5
    yharris217 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Oct 2017
    Posts
    3
    It worked! Thanks again!

  6. #6
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    You are welcome!

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

Similar Threads

  1. Replies: 3
    Last Post: 01-18-2016, 01:55 PM
  2. Finding Duplicates within a group
    By murfeezlaw in forum Queries
    Replies: 3
    Last Post: 10-01-2014, 07:38 PM
  3. Finding duplicates in two fields
    By skipnick in forum Access
    Replies: 6
    Last Post: 12-10-2013, 01:29 PM
  4. Replies: 2
    Last Post: 06-13-2013, 09:10 AM
  5. Replies: 1
    Last Post: 05-02-2012, 01:33 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