Missing 512 records in a query

[Marty Wolf]

I was setting up a query that had been troublesome so I was pulling each
element of the query separately to locate which of 5 related tables was
causing the problem.
I forgot to enter a criteria in the first element of the query so it should
have retrieved the entire table. The table contains 24100 records but the
query only retrieved 23588.
A little investigation found a few of the missing records and I can find
them in the table but they don't appear in the query.
Why don't they appear in the query? What have I done wrong that a query
can't see these records they look fine to be in the table.

Thanks

 

[Rick Brandt]

I was setting up a query that had been troublesome so I was pulling
each element of the query separately to locate which of 5 related
tables was causing the problem.
I forgot to enter a criteria in the first element of the query so it
should have retrieved the entire table. The table contains 24100
records but the query only retrieved 23588.
A little investigation found a few of the missing records and I can
find them in the table but they don't appear in the query.
Why don't they appear in the query? What have I done wrong that a
query can't see these records they look fine to be in the table.

Thanks

Are they perhaps duplicates that the query has been configured to not show?