Have these tables or data within been manipulated or obtained from some other application?
When I run a query to show ClassNo that are equal in both tables. I see strange/unexpected results.
Query1 sql
Code:
SELECT [T-Class info].ClassNo
, [T-Entries].ClassNo
FROM [T-Entries] INNER JOIN [T-Class info] ON
[T-Entries].ClassNo = [T-Class info].ClassNo;
Part of result set.
I did check your EntrantNo in your tables and they are as expected/matching.
It appears to be some sort of (data) corruption with your ClassNo????
UPDATE: CJ has identified the issue in post #6. I don't use field lookups and didn't check--my bad.