Hi Naomi, No... in your case i was referring to the actual coding of my mind.. I just use the curtemp for illustration purposes... sorry for the confusion. Again let me revise my example. This is my actual coding:

cSelectStat = "select "+lcfields +;
" FROM dride "+;
" left Join dtpprates On dtpprates.ratespk = dride.ratedtppfk "+;
" left Join dtpp On dtpp.tpppk = dtpprates.tppfk "+;
" left Join CRSCHOSEN On CRSCHOSEN.tpppk = dtpp.tpppk "+;
" left Join dpass On dpass.passpk = dride.passfk "+;
" left Join CLIENT On CLIENT.personid = dpass.personidfk "+;
" INTO Cursor crsbilling"

&cSelectStat

It triggers an error when excuting this statment:

select crsbilling

For the mean time I will try your advice.. Will get back to you. I going to my client right now and debug.