Calculate (Sum) multiple time fields

[Chris Trent]

Hi All



I am relatively new to access (i've been doing everything on Excel).

I am trying to make a logbook and I have boxes that calculate times. What I need is another field to give the total of the various times.

I have absolutely no idea how to do it. I have tried multiple searches on the internet but cannot get my expression to work. I either get a #error or i get the times displayed at concatenated text.

Im about to give up on Access and stick with excel.

Any help would be appreciated.

I've attached a screenshot of what i need to accomplish and the database.

I would need to have a total of the hours and as well as the decimals

[ranman256]

you have decimal totals, so sum them
the bottom text box must sum the decimals, not the timestamps.

=sum(txtBoxDecimals)

[Chris Trent]

Thanks for the reply. The summing of the decimals should be straight forward.

What would the expression be to sum the different time totals?

[pbaldy]

That actually won't work either, you can't sum controls, only fields in the data. You'd need this monstrosity:

=FormatDateTime((DateDiff("n",[1st Sector Start],[1st Sector End])+DateDiff("n",[2nd Sector Start],[2nd Sector End])+DateDiff("n",[3rd Sector Start],[3rd Sector End])+DateDiff("n",[4th Sector Start],[4th Sector End]))/(24*60),4)

[Chris Trent]

Thanks Paul

It worked great!

[Chris Trent]

Would I also need a monstrosity to add up the decimals? Just want to make sure i have the correct brackets in the correct places

[Chris Trent]

I figured it out.

Thanks so much for your help!

[pbaldy]

No problem. You might search on "normalization". Field names with numbers in them are a tip-off to a design flaw. What are you going to do if a flight has 5 segments? I'd have a related table for each segment, which would let you have 1 segment or 100.