Hi Barbara and Craig,

Thats fixed it.

By moving the 'On' line immediately after the 'Join' line for each table all works well.

This doesn't work!

SELECT Rteledgr.tsurname, Rteledgr.tinitials, Rteledgr.ttitle,;
  Rteledgr.transcode, Rteledgr.paymethod, Paymeths.pmshorttxt,;
  Trancode.tcshorttxt;
 FROM  rating!rteledgr INNER JOIN rating!paymeths;
    INNER JOIN rating!trancode ;
   ON  Rteledgr.transcode = Trancode.transcode ;
   ON  Rteledgr.paymethod = Paymeths.paymethod

This does work!

SELECT Rteledgr.tsurname, Rteledgr.tinitials, Rteledgr.ttitle,;
  Rteledgr.transcode, Rteledgr.paymethod, Paymeths.pmshorttxt,;
  Trancode.tcshorttxt;
 FROM  rating!rteledgr ;
	INNER JOIN rating!paymeths;
	ON Rteledgr.paymethod = Paymeths.paymethod ;
	INNER JOIN rating!trancode ;
	ON Rteledgr.transcode = Trancode.transcode

Thanks for your help both of you.
Chris