actually Iam working on the timeclock. I gave the getdate() to just get the answer. I have 2 time columns in my reports view and I need the clockin, clockout difference with...

thats great remi, thanks a lot

It worked me great........Thanks

thanks for ur help

hi the table has the data like this.first two positions represent record id, [3-8]represent internal id and next acct,code,date

01XYZ234     27838378278     12   20050912

00XYZ234     27838378278     12   20050912

the record id...