Is this possible?

  • Thread starter Thread starter OverMyHead
  • Start date Start date
O

OverMyHead

I am using Access 2007 and I have been tasked with creating a query
to
produce information, and for the life of me, I cant figure it
out...maybe you can.

We take calls from varous groups. Lets just say groups A, B, C, D, E,
F, & G.


We take calls from 7:30 am to 9:30 PM.


Using information from the fields below he wants a break down of how
many calls we get per group every half hour, by day of the week.


[Caller Type] [Create Date] [Create Time] [Day of Call]


7:00 7:30 8:00 8:30 9:00 9:30 10:00 10:30


A
B
C
D
E
F
G


Is this possible?
 
You really should have one field for DateTime. That would query to give you
date, time, month, quarter, year, day of year, day of week, etc.

The query below is based on the date and time fields being datatype DateTime
and not number or text.

TRANSFORM Count(OverMyHead.[Create Date]) AS [CountOfCreate Date]
SELECT OverMyHead.[Day of Call], OverMyHead.[Caller Type],
Count(OverMyHead.[Create Date]) AS [Total Of Create Date]
FROM OverMyHead
GROUP BY OverMyHead.[Day of Call], OverMyHead.[Caller Type]
PIVOT Format([Create Time],"hh") & Partition(Format([Create
Time],"n"),0,1440,30) ;
 
Back
Top