title: How to sum up the time in SQL access
body: <p>So I need to add up the time from one of my queries. I have volunteers that have a startTime and an EndTime. I then used this code to calculate it through a query:</p>
  
  <pre><code>SELECT v.Name, Format(v.StartTime - v.EndTime, "hh:nn:ss") AS Time_Diffrence,
  FROM VOLUNTEERS AS o, VOL_TASKS AS v, TASKS AS t
  WHERE v.Taskcode = t.Taskcode
      AND v.Name = o.Name
  ORDER BY 1;
  </code></pre>
  
  <p>Thus giving me the Time_Diffrence (noticed I just spelled difference wrong in my code) for each volunteer. But now I need to sum up the totals of the Time_Difference in another query. How would I go about doing this?</p>
  
  <p>Heres the code I have so far but it doesn't even run :/</p>
  
  <pre><code>SELECT v.Name, Format(v.StartTime - v.EndTime, "hh:nn:ss") AS Time_Diffrence,     
  Time_Diffrence = SUM(DATEDIFF(MINUTE, '0:00:00', WrkHrs)) 
  FROM VOLUNTEERS AS o, VOL_TASKS AS v, TASKS AS t
  WHERE v.Taskcode = t.Taskcode
      AND v.Name = o.Name
  GROUP BY v.Name
  ORDER BY 1 Asc;
  </code></pre>
  
  <p>Any ideas?</p>