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.