'Too complex' message !!!

[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');

 

[Duane Hookom]

This query doesn't look to complex. It must be something that comes from
qryHrsExtended.