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