> > if the JOB numer does not change every time yo do the select you can > > calculate it once into a variable > > > >>> >> SELECT job, (sum(IIF(done='yes',1,0))/count(job))*100 AS progress in your SELECT you devide the number of DONE jobs by the number of Jobs (COUNT(jobs)) if this number doesn't change while the counter runs you can calculate it once before you start to give the percentage of "done" Arnon