<div>
Perfect! Exactly what I needed. Thanks!
</div>


<div>
You are welcome!<br />
<br />
/gustav
</div>


<div>
<div class="content wysiwyg-content">
I'm running a query that needs some format help. I want to group records by hour, but I only know how to group minute-by-minute. Here's the relevant SQL:<br />
<br />
GROUP BY Format([DateRequest],&quot;mm/d<wbr />d/yyyy&quot;), Format([DateRequest],&quot;Medi<wbr />um Time&quot;)<br />
<br />
Can you help me with the formatting that would group records by hour?<br />
<br />
Thanks!
</div>
</div>


I'm running a query that needs some format help. I want to group records by hour, but I only know how to group minute-by-minute. Here's the relevant SQL:

GROUP BY Format([DateRequest],"mm/dd/yyyy"), Format([DateRequest],"Medium Time")

Can you help me with the formatting that would group records by hour?

Thanks!

MS Access Query Group By Hour

I&#39;m running a query that needs some format help. I want to group records by hour, but I only know how to group minute-by-minute. Here&#39;s the relevant SQL:

GROUP BY Format([DateRequest],&quot;mm/dd/yyyy&quot;), Format([DateRequest],&quot;Medium Time&quot;)

Can you help me with the formatting that would group records by hour?

Thanks!

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.