MS Access question

Hiroyuki Tamura
Hiroyuki Tamura used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Distinguished Expert 2017
Commented:
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.
Jason clarkDBA Freelancer
Commented:
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
Hiroyuki TamuraField Engineer

Author

Commented:
Thank you!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial