troubleshooting Question

Finding unmatched records between 2 tables in MS Access

Avatar of msibley
msibleyFlag for United States of America asked on
DatabasesMicrosoft Access
9 Comments1 Solution89 ViewsLast Modified:
I have a database in MS Access 365 containing a data on subjects, with over 300,000 rows. There are several rows for each subject. Columns for a subject are comparable for name (short text with 5 letter code), date (number with yyyymmdd), Condition (short text with "EO" or "EC"), TypeFZ (short text with "ABSF" or "ABSZ"), AgeRange(number), and Site (short text with 5 characters). There should be the same number of rows for each of the 2 TypeFZ fields. When I run queries to create 2 tables, 1 for each TypeFZ, there aren't the same number of rows in each table. One table has 38 less records than the others.

I've tried using the Find Unmatched Query Wizard, but I need to select on all of the above columns. I've tried various types of joins and syntax, but either get error messages or unusable results.
Join our community to see this answer!
Unlock 1 Answer and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros