... > ROUND(Sum(IIF(BETWEEN(Reservations.date, OldFrom, OldTo), 1, 0)*100/ ; > Sum(IIF(BETWEEN(Reservations.date, ReportFrom, ReportTo), 1, 0), 2) AS percent, ; >...However, it would be simplier to use second select for that.
SELECT ; >>> Clients.ClientName, ; >>> Sum(IIF(BETWEEN(Reservations.date, ReportFrom, ReportTo), 1, 0) as CurRes,; >>> Sum(IIF(BETWEEN(Reservations.date, ReportFrom, ReportTo), Reservations.Amount, 0) as CurAmount, ; >>> Sum(IIF(BETWEEN(Reservations.date, OldFrom, OldTo), 1, 0) as OldRes,; >>> Sum(IIF(BETWEEN(Reservations.date, OldFrom, OldTo), Reservations.Amount, 0) as OldAmount, ; >>> FROM Reservations JOIN Clients ; >>> ON Reservations.ClientCode=Clients.Code ; >>> WHERE between( Reservations.date, ReportFrom, ReportTo ) ; >>> OR between( Reservations.date, OldFrom, OldTo ) ; >>> GROUP BY Clients.Code ; >>>INTO CURSOR crsResult >>>