if the JOB numer does not change every time yo do the select you can calculate it once into a variable also can you change the DOS application in any way? Arnon >>> >> SELECT job, (sum(IIF(done='yes',1,0))/count(job))*100 AS progress >FROM >>> >> mytable GROUP BY job >>If you have a better solution, please don't keep it secret ... :-) > >Sorry, no. I was just curious if it's fast enough. :( > >Vlad > >