Why would my Query contain less records than my Table

[WonkyPython]

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?

[Welshgasman]

No idea.
Can you upload the db?

[Minty]

What's the SQL of the query you are using?

[Welshgasman]

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.

DId you save the query?
If you determined you had a table joined when you opened it, then it would appear you did not?, else the query would look normal but not behave normally.

[Micron]

Or you're going by the max autonumber value when you say 8449 but 3 an's got tossed.

[WonkyPython]

No idea.
Can you upload the db?

I don't want to upload the db I'm afraid...too much info and not for public scrutiny!