>> 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.

Is it fast enough for millions of records?!

Vlad