Tghanks Thomas

>As your SQL is something "undefined" due to the group by you should <g> -
>that is all those Max() (and you can also take Min()).

Sorry, I don't understand the above.

>ET.Mcl_Rte was not in your filed list at all - usually all fields grouped on should be selected.

Well ... it DOES appear in:

IIF( NET.Route == NET.Mcl_Rte, " ", NET.Mcl_Rte) as ContrNum

but admittedlyit'll be blank if NET.Route = NET.Mcl_Rte.

Do you think I should group on ContrNum then?

>The switches in "On" and "where" should only help vfp's optimizer, but at least the "where" aka Boris' parallell post seems to help ?
>
>>(so good to know I'm not the only one working this fine day) :-)
>
>yeah, sometimes goofing off to UT because real work is making me sweat (and no correlation with temperature and working in the uppermost floor ;-)
>
>have a cool one
>
>thomas