Select sum(ts.nHours) as totalHours, ; Sum(IIF(ts.fk_timetype_id = 1, 1, 0)) As woHours, ; ** The following is repeating the totalHours and woHours sums ** is there a way resuse those calculated columns? Sum(IIF(ts.fk_timetype_id = 1, 1, 0)) / (sum(ts.nHours) / 100) As woRatioTIA