Jump to content

tglaser

Members
  • Content Count

    1
  • Joined

  • Last visited

Community Reputation

0 Neutral

About tglaser

  • Rank
    Newbie
  1. tglaser

    Adding a Summary

    Hello , i am struggling to identify how to add a summary row to a query I am implementing. I have 2 columns, Name, time worked, I want to identify two things; 1. the total time worked per name, and 2 the total time worked by everyone. Can you help ? Current Query: SELECT Name, sum(hours) AS Hours FROM timecard Group by Name; Goal shown below. Name Hours John 5 Mary 6 Ed 7 Total 18<----THIS IS THE ROW I NEED TO ADD!!!
×
×
  • Create New...