Windows 10 
Access 2016
Query Help (or some other way to accomplish this)
Good afternoon!
I have a database that tracks data keyed for an entire week off our incoming forms. This weekly database has about 2 million records (it is broken down by piece of data such as name, address, etc.) that is used across the company.
What I am trying to do is consolidate this data down a bit to make it more manageable for some forecasting and trending needs. If it wasn't so large, I would throw it into a pivot table and bam I have what I need. BUT....that's not possible so I need a query or a new table to help trim this down a bit.
The fields I am working with are:
KeyerID (important)
Keyed data
KeyedTime (important)
KeyedDate (important)
SentTime (Important - this is a date/time field)
There are some other miscellaneous fields in the table but the ones about that I have listed as "important" are the ones I need to include in the query. What I want to accomplish is to group this data as follows:
KeyerID:
SentTime: I want to sum the KeyedTime for an entire hour for each KeyerID for each KeyedDate in the database. So it would look something like:
KeyerID: John Smith
Date: 10/16/2017
SentTime: 10/16/2017 7:00 AM
KeyedTime: 123456 (this would represent the sum of all the time spend keying items in the 7am hour).
Does this make sense? Is it attainable? There could be hundreds of records that would fall into this bucket with all kinds of various time stamps. I just want to see the top of the hour time stamp such as 6am, 7am, etc. I am confident this is fairly simple, but my brain is not working properly right now to accomplish this. Thank you in advance for your assistance - greatly appreciated!!!
Reply With Quote
