peter wrote: >What i want to do is be able to get a total number of hours for the job. > > SELECT SUM(Hrs) FROM records WHERE Ref_No = 'D2071'; Sean