I don't understand how this can happen:
I have a table of 8449 records with an Auto-number set to the Primary Key.
I then created a Query with one column...the Primary Key.
I noticed that there are only 8446 records.
I have performed a Compact and repair operation.
How can this happen?
UPDATE
I have found that I had previously added a related table to this query and then removed it. That linked table had 3 blank fields.
After I removed the table from the query I would have expected it to return to the complete number of records, but it didn't.
Is this a bug or what?