>With Thisform > ldStartCurr = .dStartDate1 > ldEndCurr = .dEndDate1 > ldStartPrev = .dStartDate2 > ldEndPrev = .dEndDate2 >EndWith && The 2 date ranges > >Wait WINDOW "ETM Data: Calculating Numbers of Trips within the Time periods ..." NOWAIT NOCLEAR >SELECT DISTINCT ps.*, ; > IIF( ps.CurrPass > 0, oc.Multiplier, 0.00) as Mult2, ; > IIF( ps.PrevPass > 0, oc.Multiplier, 0.00) as Mult1, ; > IIF( ps.CurrPass > 0 and oc.Multiplier > 0, ; > ps.CurrPass * oc.Multiplier, ; > IIF( ps.CurrPass > 0 and EMPTY( oc.Multiplier), ps.CurrPass, 0000000.00)) as Trips2, ; > IIF( ps.PrevPass > 0 and oc.Multiplier > 0, ; > ps.PrevPass * oc.Multiplier, ; > IIF( ps.PrevPass > 0 and EMPTY( oc.Multiplier), ps.PrevPass, 0000000.00)) as Trips1 ; >FROM csrETMPassengers ps ; > JOIN OpClass oc ; > ON ps.Operator == oc.Operator; > AND ps.Class == oc.Class ; > ORDER BY ps.Operator, ps.OpDesc, ps.Route, ps.Class ; > INTO CURSOR csrStep2 READWRITE >>