'Too complex' message !!!

  • Thread starter Thread starter Ryan
  • Start date Start date
R

Ryan

I ran the following crosstab query and got an 'expression
too complex to be evaluated' message. It happened after I
added the IN clause to the PIVOT statement.
Any clues??

PARAMETERS [From-Sunday] DateTime, [To-Saturday] DateTime;
TRANSFORM Sum(qryHrsExtended.hours) AS SumHours
SELECT qryHrsExtended.dept, qryHrsExtended.engineer,
qryHrsExtended.category, Avg(SumHours) AS AvgHours, Sum
(qryHrsExtended.hours) AS TotHours
FROM qryHrsExtended
GROUP BY qryHrsExtended.dept, qryHrsExtended.engineer,
qryHrsExtended.category
ORDER BY qryHrsExtended.dept, qryHrsExtended.engineer,
qryHrsExtended.category
PIVOT qryHrsExtended.weekending IN
('Wk1', 'Wk2', 'Wk3', 'Wk4', 'Wk5', 'Wk6', 'Wk7', 'Wk8');
 
This query doesn't look to complex. It must be something that comes from
qryHrsExtended.
 
Back
Top