Update cTime SET [tTime] =( Select (Format$(SUM([pTime] + [bTime]),"HH\:nn\:ss")) From cTime  GROUP BY [oID]);

How to Update the above query on a single table
I do;

• Edited by Kenan YILMAZ 14 hours 24 minutes ago

Hello Kenan,

This is a Forum for SQL Server, not MS Access; you should better post your question to a more related Forum => https://social.msdn.microsoft.com/Forums/office/en-US/home?forum=AccessDev