Results 1 to 3 of 3
  1. #1
    JSH2017 is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2017
    Posts
    3

    Duplicate Query Help-Need to find duplicated data in multiple columns or multiple queries

    Please keep in mind, I am very new to Access. If solution is complicated or there may be multiple ways to get the result feel free to share.
    I am trying to figure out how to look for duplicates between multiple columns and/or multiple queries. The below is only meant as an example. I know the answer but I can't replicate that answer in Access.

    What I do know
    Querying for duplicates in specific columns. Example: I know how to find how many duplicates for Car A1 there are in the F1 column or Bcar A1 in the F2 column. I also created two specific Queries called, "Duplicates for F1" and "Duplicates for F2".

    What I need to know
    I need to figure out how to find duplicated data that exists in both columns. Example: I know that Car A1 in column F2 is in F1. How do you show that in Access?


    Raw Data


    F1 F2
    Inventory Revised Inventory
    Car A1 Bcar A1
    Car A2 Bcar A2
    Car A3 Bcar A3
    Car A4 Bcar A4
    Car A5 Bcar A5
    Car A6 Bcar A6
    Car A7 Bcar A7
    Car A8 Bcar A8
    Car A9 Bcar A9
    Car A1 Bcar A10
    Car A2 Bcar A11
    Car A3 Bcar A12
    Car A4 Bcar A1
    Car A5 Bcar A2
    Car A6 Bcar A3
    Car A7 Bcar A4
    Car A8 Bcar A5
    Car A9 Bcar A6
    Car B1 Bcar A7
    Car B2 Bcar A8
    Car B3 Bcar A9
    Car B4 Bcar A10
    Car B5 Bcar A11
    Car B6 Bcar A12
    Car B7 Bcar B1
    Car B8 Bcar B2
    Car B9 Bcar B3
    Car B1 Bcar B4
    Car B2 Bcar B5
    Car B3 Bcar B6
    Car B4 Bcar B7
    Car B5 Bcar B8
    Car B6 Bcar B9
    Car B7 Bcar B10
    Car B8 Bcar B11
    Car B9 Bcar B1
    Bcar B2
    Bcar B3
    Bcar B4
    Bcar B5
    Bcar B6
    Bcar B7
    Bcar B8
    Bcar B9
    Bcar B10
    Bcar B11
    Car A1

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Do you understand Normalization? What is your table(s) structure(s)?

    I found this via Google https://www.gcflearnfree.org/access2...cates-query/1/

  3. #3
    JSH2017 is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2017
    Posts
    3
    Quote Originally Posted by orange View Post
    Do you understand Normalization? What is your table(s) structure(s)?

    I found this via Google https://www.gcflearnfree.org/access2...cates-query/1/
    I am currently working with Normalization on my data. I will reply once I either confirm that was the fix or with any other questions. Thanks orange!

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

Similar Threads

  1. Replies: 1
    Last Post: 04-18-2016, 11:48 AM
  2. Replies: 3
    Last Post: 08-31-2015, 09:04 AM
  3. Replies: 1
    Last Post: 04-30-2012, 08:42 AM
  4. Multiple Duplicate Queries in One?
    By NewtoIT in forum Programming
    Replies: 0
    Last Post: 03-10-2011, 04:57 PM
  5. Replies: 0
    Last Post: 03-09-2011, 02:59 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