sightsound
New member
- Local time
- Today, 02:30
- Joined
- Jul 3, 2019
- Messages
- 4
Hi All,
I’m back again with another question, this time in regard to sorting Date\Time date in a table.
I have a table which logs when jobs were added Date\Time and I’m trying to break this down into a chart of hourly slots, to see which the busiest time period over the year.
In the chart the date range needs to be the whole of the year, but broken down to the time.
The data in the table is stored as below.
08/07/2019 08:10:00
08/07/2019 14:15:00
08/07/2019 17:10:00
09/07/2019 08:56:00
09/07/2019 17:56:00
What I’m trying to do is have the chart dispaly like the bad example below.
I have created a Query, but unsure of the criteria.
__2____ 0_____ 0_____0_____1_____1________1
<9am __9am__10am__11am__2pm__5pm__ > 5:30pm
many thanks
James
I’m back again with another question, this time in regard to sorting Date\Time date in a table.
I have a table which logs when jobs were added Date\Time and I’m trying to break this down into a chart of hourly slots, to see which the busiest time period over the year.
In the chart the date range needs to be the whole of the year, but broken down to the time.
The data in the table is stored as below.
08/07/2019 08:10:00
08/07/2019 14:15:00
08/07/2019 17:10:00
09/07/2019 08:56:00
09/07/2019 17:56:00
What I’m trying to do is have the chart dispaly like the bad example below.
I have created a Query, but unsure of the criteria.
__2____ 0_____ 0_____0_____1_____1________1
<9am __9am__10am__11am__2pm__5pm__ > 5:30pm
many thanks
James