Type Mismatch

[Mattymatt79]

Im trying a query here and I keep getting a type mismatch. Whenever I take out the MRNO table and fields that I want from it it works fine but as soon as I put that in I get the error...

This is the SQL code if this helps
SELECT MAININFO.LAST, MAININFO.FIRST, MAININFO.MI, MAININFO.SSN, PAYGRADES.PayGrade, MAININFO.MRNO, MRNO.MRNO, MRNO.STATUS
FROM MRNO RIGHT JOIN (PAYGRADES INNER JOIN MAININFO ON PAYGRADES.PayGrade = MAININFO.PAYGRADE) ON MRNO.MRNO = MAININFO.MRNO
ORDER BY MAININFO.PAYGRADE DESC , MAININFO.LAST;

 

[Mattymatt79]

Im thinking it has something to do with my MRNO table.
I cant do an update query either. Any Info would be GREATLY appreciated

 

[Mattymatt79]

no pat, MRNO in the actual table MRNO is an autonumber, in the main table it is text... I took your advice and changed the fields of last and first to LastName and FirstName, didnt change a thing though
any suggestions?

 

[Mattymatt79]

Thanks So much... I didnt realize in the thing that I did before with the same fields that it was autonumber and number as soon as you wrote that I checked and you are SO right.
thanks again for the help