How can I query time frame from date time field in Access?
Posted on 2014-12-11
I have a database that tracks a transaction. I want to be able to write a query that shows when this transaction happens between the hours of 7:00 am and 9:30am each day. I also want to be able to see this week over week as a trend. I have 3 available fields to use that are date/time related. I have a "Date/Tm" field that shows "12/2/2014 7:17:12 AM". I have a "Date" field that shows "12/02/2014". I also have a "Day of the Week" field that shows "Tuesday". I also have fields for "Employees", "Locations", and "Transactions"
I am envisioning writing a query that could be exported and used in a pivot table to show the employee, the location, and the amount of transactions that occurred each week by day and within the specified time frame. I have attached an example of what I would like to see in the resulting query.