Crosstab Query Error - Data type mismatch in criteria expression

[Arvin]

Hello,

I'm trying to create crosstab query and I'm running into some issues. I'm basing the crosstab query on another query...which has no problems...

Here is my 1st Query which works (SQL View)

SELECT tblDepartments.Department, tickets.C29, Format([C30],"Short Time") AS nTime, Nz([OPER],"Blank") AS Staff, Val(Left([nTime],2)*60)+Val(Right([nTime],2)) AS nMins, tickets.UPDATED
FROM tickets INNER JOIN tblDepartments ON tickets.GRP = tblDepartments.Group
WHERE (((tblDepartments.Department) Not In ("Wireline Residential Resale","Internet ADSL Resale","Internet Dialup Resale","Internet Wholesale DSL")) AND ((tickets.C29) Not In ("NCAMS","Data","Wireline Residential Resale","Internet ADSL Resale","Internet Dialup Resale","Internet Wholesale DSL")) AND ((Format([C30],"Short Time"))<>"--Please Select--"))
ORDER BY tblDepartments.Department, tickets.C29;

Here is my Crosstab Query (SQl View)

TRANSFORM MinsToTime(Sum(CInt(nz([nMins],0)))) AS nTime
SELECT QryDetailsVariable.Department, MinsToTime(Sum(CInt(nz([nMins],0)))) AS Total
FROM QryDetailsVariable
GROUP BY QryDetailsVariable.Department
PIVOT QryDetailsVariable.Staff;

Any ideas?

Thank you in advance

 

[James Dudden]

What are the issues you are running in to?