Stumped on unmatched query

[lbsstacey]

I have an unmatched query which has stopped performing the way it should.
When I create a new unmatched query that looks identical to the original one
(down to the settings in Properties), the new unmatched query returns my
expected results while the original one returns no records.

Is there a setting which needs to be reset when the tables that the query
references are updated? I don't know what else could be causing the
discrepancy.

 

[John W. Vinson]

I have an unmatched query which has stopped performing the way it should.
When I create a new unmatched query that looks identical to the original one
(down to the settings in Properties), the new unmatched query returns my
expected results while the original one returns no records.

Is there a setting which needs to be reset when the tables that the query
references are updated? I don't know what else could be causing the
discrepancy.

Never seen that happen!

Doublecheck that Tools... Options... Track Name Autocorrect is unchecked; it's
called Name Autocorrupt with good reason. Then perhaps you could post the SQL
of both queries.