Find the Busiest Times of the Day Using the Hour, Minute, and Second Functions in Microsoft Access

[@kerrywsmyth]

I’m going to be brutally honest - I really don’t WANT to share Rick publicly. He is my secret weapon. I pay to be a member and will be upgrading probably before the end of the year. But as much as I want to keep him a secret, I also understand that helping him earn more will encourage him to keep making videos and that helps me too. Anyway if you’re even remotely interested in learning how to make professional databases, I don’t know anywhere else to go for the price. It’s worth every penny. It’s actually cheap when you consider the cost of a Computer Science degree.

[@599CD]

It puts the primary key field in the table or it gets the hose again!

[@599CD]

Haha. Thank you for the kind words. I appreciate it. And yeah... everyone else... listen up. :)

[@minnieminx2216]

Oh I thought I had found my answer but it’s not worked for me ; I have a time field in an access table, shows 17:01:45; I then used the hour function in my query but it just didn’t work, comes up with a very unhelpful comment …. There was an error compiling this function . I just want to see the hour part