MS Access question

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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Distinguished Expert 2017
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
Its not much clear what you want have a look this may help you but not sure:
Hiroyuki TamuraField Engineer


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