YO!

That works! Thank you very much Boris. You seem to come to your soln. in as much time as it takes the email to reach you and you to reply to me.

Hmmm, later on in the form the cursor disappears and I get an error now. I have to look into that.

Laters

Terry
>
>Here final query :-)))
>

>SELECT NET.Operator, NET.Route, NET.Start_Date, NET.End_Date, NET.RorF, NET.Passengers, ;
>	IIF( NET.Route == NET.Mcl_Rte, "    ", NET.Mcl_Rte) as ContrNum, ;
>	0000000 AS CurrPass, 0000000 AS PrevPass, op.Desc as OpDesc, rf.ServType ;	
>  FROM NotETM NET ;
>       JOIN Operator op  On NET.Operator == op.Code ;
>       JOIN RteFam   rf  On NET.Operator == rf.Operator and NET.Route    == rf.ERoute ;
>  WHERE ((m.ldStartCurr BETWEEN NET.Start_date AND NET.End_date)          OR;
>         (m.ldEndCurr   BETWEEN NET.Start_date AND NET.End_date)          OR;
>         (NET.Start_date < m.ldStartCurr AND NET.End_date > m.ldEndCurr)  OR;
>         (m.ldStartPrev BETWEEN NET.Start_date AND NET.End_date)          OR;
>         (m.ldEndPrev   BETWEEN NET.Start_date AND NET.End_date)          OR;
>         (NET.Start_date < m.ldStartPrev AND NET.End_date > m.ldEndPrev)) AND;
>         NET.Operator == lnOpCode;
>  ORDER BY    NET.Operator, NET.Route &&;
>INTO CURSOR csrNotETMPassengers NOFILTER READWRITE
>