M Mitch Jan 9, 2009 #1 I have a table with hourly and daily information. I want to use a query to sum the hourly data at the daily level. How do I do that?
I have a table with hourly and daily information. I want to use a query to sum the hourly data at the daily level. How do I do that?
T Tom van Stiphout Jan 9, 2009 #2 On Fri, 9 Jan 2009 05:04:03 -0800, Mitch In the query design grid, use the button with a capital sigma on it to add summing features (technically called a "group by" query). -Tom. Microsoft Access MVP
On Fri, 9 Jan 2009 05:04:03 -0800, Mitch In the query design grid, use the button with a capital sigma on it to add summing features (technically called a "group by" query). -Tom. Microsoft Access MVP
