How do I run an Access query to add time?

[srvblues00]

I have a table in an Access database that has a time field in an h:mm:ss format. What is the correct syntax in a query to get it to add up all the fields in the table? I have tried sum, but not surprisingly, that didn't work. Thx!

 

[srvblues00]

anyone?

 

[bunker]

Don't ask me how to do it, but you first have to convert the field to seconds, add it, then convert it back to hh.mm.ss.

If possible, just store it as seconds, that would be much better.