Columnar Report Question

[JV]

Hello fellow Access people - I am working with a call center, and I
need to set up a report like this:


Client 9/19/2005 9/20/2005 9/21/2005 TotWeek
# Calls 300 246 432 991
ASA :40 :30 :23 :30
30 Sec Ans 222 223 224 599
% in Serv 60% 59% 65% 61%
Abandoned Calls 23 32 31 97
% Abn 10% 12% 13% 11%

Member 9/19/2005 9/20/2005 9/21/2005
# Calls
ASA Same Kind Of info
30 Sec Ans
% in Serv
Abandon Calls
% Abn


In other words, I need a columnar report with Dates based on a field in
a query as the column heading. The rows are also fields in the
query...the query looks like this:

Category # Of Calls ASA 30SecAns %inServ AbandonCalls %Abn Date
Member 300 :30 5 50% 20 4% 09/20
Member 230 :29 4 49% 19 2% 09/21
Client 210 :23 1 90% 23 1% 09/20
Client 210 :23 1 90% 23 1% 09/20

etc.


I've tried everything (Crosstab, Pivot), but nothing works.

Anyone ever come across requirements like these and come up with a
solution?

Thanks.

 

[Duane Hookom]

Do you have a table structure and sample records that you would like to
share?

 

[JV]

These fields are all either calculated or from a lookup table....the
root table is an odbc linked table to a Call Center Manager software
product (Avaya). Here is a shortened example of a record:

row_date acd vdn vector inflowcalls anstime acdcalls acdtime
9/11/2004 1 3004 23 0 0 0 0

 

[Duane Hookom]

I'm afraid this doesn't help me too much. There are examples of crosstab
reports at http://www.invisibleinc.com/divFiles.cfm?divDivID=4

 

[JV]

Duane - Thanks for your reply.


The date headers across the top should be based on the dates in the
query.

The query looks like this:

Ctgry ASA Calls SumOfanstime PercServ TotAbn Date
Member 0:55 282 14182 43% 2 10/01/04
Member 0:56 256 13118 44% 3 10/02/04
Member 0:54 245 11234 45% 4 10/03/04

I want to create a report based on this query that looks like this:

10/01/05 10/02/05 10/03/05 Week Total

Member
ASA 0:55 0:56 0:54 0:53
Calls 286 256 243 678
Ans Time 14182 13188 11234 12345
% Serv 43% 44% 45% 44%
Total Abn 2 3 4 9


A crosstab query will only let me have one calculated field. I looked
at the crosstab reports and they seem to have the same problem.

Let me know if I am explaining this correctly or if I am missing
something.


Thanks in advance.

 

[Duane Hookom]

I have samples in the reports of multiple values. You may be able to use a
multi-column report with help from
http://support.microsoft.com/default.aspx?scid=kb;en-us;210044&Product=acc.