K
Kelvin Middleton
Hi all, please help.
I have a DB which stores call data downloaded from an ACD (Call Centre
Server recording call information), this information specifically is
recording in half hours slots and counts the number of calls that come down
a specific telephone number.
I can sucessfully manipulate this information, so for example I have a query
which gives me the total call volumes received by half hour by date for a
specific telephone number or group of telephone numbers. The issue is that
if for instance there are no calls made on a specific tel number then the
ACD doesn't report it, it just skips that half hour segment, so when my
query returns the data instead of returning 48 half hours slots some of
which may be empty it just returns the number of slots with data in. I want
to do is for the query to return all 48 half hour slots and just leave blank
the call volumes for this which don't/shouldn't have any.
I've tried creating a seperate table which simply contains 48 rows and each
holds a different half hour eg. 00:00, 00:30, 01:00 and so on. I then place
this in the query along with my table that stores the call volumes and join
the 2 time fields with a join that says to return all records from
tblAllHalfsHours and only those records which match in tblCallData. However
this doens't work, I just get the rows which have data in and not the padded
out version. Has anyone got a solution please? I'm using Access 2000.
Many thanks,
Kelvin
I have a DB which stores call data downloaded from an ACD (Call Centre
Server recording call information), this information specifically is
recording in half hours slots and counts the number of calls that come down
a specific telephone number.
I can sucessfully manipulate this information, so for example I have a query
which gives me the total call volumes received by half hour by date for a
specific telephone number or group of telephone numbers. The issue is that
if for instance there are no calls made on a specific tel number then the
ACD doesn't report it, it just skips that half hour segment, so when my
query returns the data instead of returning 48 half hours slots some of
which may be empty it just returns the number of slots with data in. I want
to do is for the query to return all 48 half hour slots and just leave blank
the call volumes for this which don't/shouldn't have any.
I've tried creating a seperate table which simply contains 48 rows and each
holds a different half hour eg. 00:00, 00:30, 01:00 and so on. I then place
this in the query along with my table that stores the call volumes and join
the 2 time fields with a join that says to return all records from
tblAllHalfsHours and only those records which match in tblCallData. However
this doens't work, I just get the rows which have data in and not the padded
out version. Has anyone got a solution please? I'm using Access 2000.
Many thanks,
Kelvin