> SELECT job, (sum(IIF(done='yes',1,0))/count(job))*100 AS progress FROM > mytable GROUP BY job Thank you Matt. It's exactly what I need.