Crosstab + Select Query = Type Mismatch in Expression

[padlocked17]

I've got a Select Query that looks like:

SELECT IIf(IsNull([ARMS_Due_DT]) And [SemiAnnual_REQ]>0,"Yes",Null) AS GeneratedDue, IIf(DatePart("q",Date())>2,[ITS_Current_Events_Fixed]![2SemiAnnual_ACC],[ITS_Current_Events_Fixed]![1SemiAnnual_ACC]) AS Accomplished, IIf([SemiAnnual_REQ]-[Accomplished]>0,[SemiAnnual_REQ]-[Accomplished],0) AS Remaining, IIf([Qty_Freq]=0,Null,[Qty_Freq] & " " & [Freq]) AS Frequency, ITS_Current_Events_Fixed.Unit, ITS_Current_Events_Fixed.SSAN, ITS_Current_Events_Fixed.Name, ITS_Current_Events_Fixed.LAST4, ITS_Current_Events_Fixed.Flyer_Type, ITS_Current_Events_Fixed.CPOS, ITS_Current_Events_Fixed.TaskID, tblTasks.Task_ID, tblTasks.TaskDescription, tblTasks.TaskLineNum, tblTasks.TaskRemarks, tblTasks.SectionID, tblTaskTypes.SectionName, tblTaskTypes.SectionPageNum, tblTaskTypes.SectionRemark, ITS_Current_Events_Fixed.ACC_DT, ITS_Current_Events_Fixed.ARMS_Due_DT, ITS_Current_Events_Fixed.Due_Date_Flag, ITS_Current_Events_Fixed.Qty_Freq, ITS_Current_Events_Fixed.Freq, ITS_Current_Events_Fixed.SemiAnnual_REQ, ITS_Current_Events_Fixed.Qtr_REQ, ITS_Current_Events_Fixed.Month_REQ, ITS_Current_Events_Fixed.[1Qtr_ACC], ITS_Current_Events_Fixed.[2Qtr_ACC], ITS_Current_Events_Fixed.[3Qtr_ACC], ITS_Current_Events_Fixed.[4Qtr_ACC], ITS_Current_Events_Fixed.[1SemiAnnual_ACC], ITS_Current_Events_Fixed.[2SemiAnnual_ACC], ITS_Current_Events_Fixed.SIM_ACC
FROM (ITS_Current_Events_Fixed LEFT JOIN tblTasks ON ITS_Current_Events_Fixed.TaskID = tblTasks.TaskID) LEFT JOIN tblTaskTypes ON tblTasks.SectionID = tblTaskTypes.SectionID
WHERE (((ITS_Current_Events_Fixed.Name) Is Not Null) AND ((ITS_Current_Events_Fixed.TaskID) Is Not Null));

And a Crosstab Query that looks like:

TRANSFORM Max([1AllEvents].ACC_DT) AS MaxOfACC_DT
SELECT [1AllEvents].SSAN, [1AllEvents].TaskID
FROM 1AllEvents
WHERE ((([1AllEvents].TaskID) Is Not Null))
GROUP BY [1AllEvents].SSAN, [1AllEvents].TaskID
PIVOT [1AllEvents].Method;

I'm then trying to combine the two above in a query that looks like the following:

SELECT ITS.Unit, ITS.SSAN, ITS.Name, ITS.LAST4, ITS.Flyer_Type, ITS.CPOS, ITS.TaskID, ITS.Task_ID, ITS.TaskDescription, [1LastDone].N, [1LastDone].S, ITS.TaskLineNum, ITS.TaskRemarks, ITS.SectionID, ITS.SectionName, ITS.SectionPageNum, ITS.SectionRemark, ITS.ACC_DT, ITS.ARMS_Due_DT, ITS.Due_Date_Flag, ITS.Qty_Freq, ITS.Freq, ITS.SemiAnnual_REQ, ITS.Qtr_REQ, ITS.Month_REQ, ITS.[1Qtr_ACC], ITS.[2Qtr_ACC], ITS.[3Qtr_ACC], ITS.[4Qtr_ACC], ITS.[1SemiAnnual_ACC], ITS.[2SemiAnnual_ACC], ITS.SIM_ACC, ITS.Frequency, ITS.Remaining, ITS.Accomplished, ITS.GeneratedDue
FROM 1LastDone RIGHT JOIN ITS ON ([1LastDone].TaskID = ITS.TaskID) AND ([1LastDone].SSAN = ITS.SSAN);

And after all of that hard work and careful consideration I get:

"Type mismatch in expression"

I attached some screenshots as well.

Any help would be greatly appreciated.

 

[Guus2005]

You have to compare the type of the fields that you've put in the where clause. Apparently they don't match. (Type mismatch)

HTH