The Date data type in Access is intended for timestamps, not durations.
Rather than attempting to add durations in that manner, you should store the
durations as Long Integers (either as total seconds or total minutes,
depending on what resolution you require) and add them together.
answer: just add them together
8:00+2:00+3:00
If they contain a datepart you can use
Time(Date1) + Time(Date2) + Time(Date3)
whickh is sufficient if the result is less than 24:00
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
