Time

[turks67 via AccessMonster.com]

How do I add time in a query. For example 45:15 + 16:27 + 45:37. What is
wrong with this?

 

[Jeff Boyce]

What is wrong with what?

Access has no idea what you mean by "45:15". ... and I'm a little confused,
too!

Is that supposed to be 45 minutes and 15 seconds? If so, and if you want to
use Access, you'll need to tell it how to translate that into the lowest
terms, so it can do the math. 45 minutes is (45 x 60) seconds, plus 15
more.

Once you've told Access how to do that (hint: try a query), you can add the
values. Of course, the answer will be in seconds, so if you need to see it
in hh:mm:ss format, you'll also need to tell Access how to do THAT!

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[DStegon via AccessMonster.com]

Add time IN a query????? What?

Are you trying to get a recordset based on a query and add up all the "time"
fields within the records?