Hi All
I have three fields in MS Access Database.The first is hours the second Minutes and the third is Seconds. I want to be able to add these fields and any carry over from seconds to minutes(Over 59 seconds)minutes carry over to hours
Thanks

Brendan Bartley

__________________
Brendan Bartley

Do something like:

HoursRevised=int(360*Hours+60*Minutes+Seconds)/360)
MinutesRevised=int((60*Minutes+Seconds)/60)
SecondsRevised=int((Seconds)/60)

Then replace hours with HoursRevised, Seconds with Seconds Revised, Minutes with Minutes Revised.

Or you could just maintain total seconds, and then populate the hours and minutes/seconds field with the integer method.

There might be a more elegant solution, but thats one I can think of off the top of my head.

Hi Trap
Where exactly do I use this code in a form or report and secondly do I use a text box for the result
Thanks

Brendan Bartley

I was thinking that you would just use the formulas in your query.