MS Access question
I have a field contains time format data for 3 years.
If I want to create a query, colum: year, row: every hour, count, what shoul i do?
If I want to create a query, colum: year, row: every hour, count, what shoul i do?
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Try using the crosstab wizard. It should give you options for picking out year and hour. If not, post back with a small sample of data and someone will help you.
Its not much clear what you want have a look this may help you but not sure: https://support.microsoft.com/en-us/help/290136/how-to-create-a-running-totals-query-in-microsoft-access
Premium Content
You need an Expert Office subscription to comment.Start Free Trial