i think jack pretty much has the idea...i'm looking for a solution for this problem right now my self.

i originally used the quirky update to test the transaction number for the date for that employee...eg, punch 1 is time in, punch 2 is out. punch 3 is in...and so on...

one way i figured out to determine the number of hrs that makes up a day...

to the original poster, did you ever get the problem solved? well, if you did...im interested in finding out how you did it.

thanks.