All, this should be so simple and yet I can't figure it out. I have a table containing hourly volumes for a number of days (see excerpt below).
How do I write an access query that in addition to finding the maximum "totvol" for each day also returns the hour in which TotVol occurs? So, from the table below I need to return two rows:
Day Hour TotVol
18-Jun-13 15 1563
19-Jun-13 5 1111
Retrieving the maximum TotVol value for each day is easy, but how do I get the associated hour?
You can do that with two queries. In the first query, add day and TotVol. In design view, select Totals. Set day to group and TotVol to Max. The sql look like this:
SELECT tblYourTable.Day, Max(tblYourTable.TotVol)
Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.
No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents.
Type out your initial …