Crosstab Calculation Anguish

C

C.J.

Hi:

I am using Access 2000.

In a nutshell, I need to take the results from my
crosstab, with custom column headings, and add some of the
results together for use in my report.

My crosstab SQl is as follows:

TRANSFORM Avg(qryDaysToApproval.Days) AS AvgOfDays
SELECT qryDaysToApproval.bytWorkArea, Avg
(qryDaysToApproval.Days) AS [Average Of Days]
FROM qryDaysToApproval
GROUP BY qryDaysToApproval.bytWorkArea
PIVOT qryDaysToApproval.strType In
("DRS","EZE","GEO","LOC","MLL","MLP","MSC","MSL","PIL","PLA
","REC","ROE","SMC","SME","SML");

For example: I need to find the average of the values of
DRS and EZE and GEO from Work Area 1. The crosstab is
finding the correct individual values but I do not know
how to combine them together as needed.

Is the crosstab making the values text because the type
field is text? If so, how do I convert this and do I
convert it in a query or in the report?

Thanks for your help.
 
Top