title: How can I make a query that will sort data on two criteria then add all values corresponding to that criteria from the initial table/query?
body: <p>I have an Access Database with a query, called Billing Hours which contains the following fields: Project Name, Customer, Employee, Date Worked, Work Description, Billable Hours and Non-billable Hours. </p>
  
  <p>What this query does is show on each row the date on which an employee worked, what customer he worked for, what project, what he did, how many hours were billable and how many were non-billable.</p>
  
  <p>I want to make a new query, based on this that will sum up total Billable Hours and Non-billable Hours spent by each Employee on each Project Name, and I can't seem to find a way to do that. </p>
  
  <p>I have managed to make queries that will extract total number of hours per project and total number of hours per employee, but as a whole, not per project AND per employee. </p>
  
  <p>I have tried using DISTINCT, UNION, sorting, joining on, joining left, right and center, nothing seems to work. </p>
  
  <p>Furthermore what really doesn't help is that it's been probably 18 years since I last worked in SQL, and the first time I'm dealing with Access, this is sort of something I'm trying to help someone out with and it's frustrating. </p>
  
  <p>The result would look something like</p>
  
  <hr>
  
  <p>Employee_Name_1 Project_Name_1 Number_of_BH1 Number_of_NBH1</p>
  
  <p>Employee_Name_1 Project_Name_2 Number_of_BH2 Number_of_NBH2   </p>
  
  <p>Employee_Name_2 Project_Name_1 Number_of_BH3 Number_of_NBH3</p>
  
  <p>and so on</p>
  
  <hr>
  
  <p>If anyone could point me in the right direction, that would help a lot. I'm guessing it's not even that hard. If I can provide any further information, please let me know. </p>
  
  <p>Cheers!</p>