Query to add 2 times together

[GlenLynam]

Hi there,

I have 2 times from 2 queries the format is hh:mm:ss. I need to add these times together ie the times 10:00:00 and 10:00:10 would become 20:00:10. Ok i can get it so the results are hh:mm:sshh:mm:ss. I have this isn the query and feel it should work as it is how i got the durations from the data in the first place.

Total: Format(Sum(TimeValue(qryTSOut_Duration!totalcall+qrytsin_duration!totalcall)),"hh:nn:ss")

but it tells me it is to complicated and i should add some variables any ideas??

Thanks

Glen

ps. Incase it helps here is the SQL code

SELECT [SMDR In Order].Party1Name, qryTSOut_Duration.TotalCall, qryTSIn_Duration.TotalCall, Format(Sum(TimeValue([qryTSOut_Duration]![totalcall]+[qrytsin_duration]![totalcall])),"hh:nn:ss") AS Total
FROM ([SMDR In Order] INNER JOIN qryTSOut_Duration ON [SMDR In Order].Party1Name = qryTSOut_Duration.Party1Name) INNER JOIN qryTSIn_Duration ON [SMDR In Order].Party1Name = qryTSIn_Duration.Party1Name
GROUP BY [SMDR In Order].Party1Name, qryTSOut_Duration.TotalCall, qryTSIn_Duration.TotalCall
ORDER BY qryTSOut_Duration.TotalCall DESC;

 

[SkipVought]

Hi,

Format(Sum(qryTSOut_Duration!totalcall+qrytsin_duration!totalcall),"hh:nn:ss")

Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}

 

[GlenLynam]

Thanks for the response but im geting the same message about it being to complicated and that i should assign some variables. Any other ideas??

 

[PHV]

And this ?
Format(qryTSOut_Duration.TotalCall + qryTSIn_Duration.TotalCall, 'hh:nn:ss') AS Total

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[GlenLynam]

Nope but i have cracked it!!! After 2 days of trying!

Total: TimeValue(qryTSOut_Duration.TotalCal)+TimeValue(qryTSIn_Duration.TotalCal)

Thanks to all for your assistance