> if the JOB numer does not change every time yo do the select you can > calculate it once into a variable You lost me here. > also can you change the DOS application in any way? Nope. > 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 > > > >