tglaser joined the community
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!!!