Missing 512 records in a query

  • Thread starter Thread starter Marty Wolf
  • Start date Start date
M

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
 
Marty said:
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
Click to expand...

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