Type Mismatch

[Hakutabe]

i have a Query called Personell which consists of

tblPersonell; "Personal Number (key)". "FirstName". "LastName". "Rank"
tblPersonellRanks; "RankCode(key)". "RankName".

now the query works fine perfectly i made the same thing with qryDrivers
tblDrivers and tblDriversRanks have same things but the Query for Drivers when i open it types "Type Mismatch in Expression" but the Personell still works and qryDrivers starts working only after i remove tblDriversRanks and i dont understand why help please

 

[pbaldy]

At a guess, the fields in the join (presumably the rank fields) have different data types.

 

[Hakutabe]

ahhh yess thanks i looked everything and didnt notice that the Rank is a text instead of a number

 

[pbaldy]

Happy to help!