L
lmossolle
I am using office 2007. I had this query in Office 03 working, now I get a
data type mismatch in criteria expression. Could someone please assist?
Thanks,
Lee
SELECT
Sum(IIf(Assigned,1,0)) AS [Cumulative Actions],
Sum(IIf(Status="Returned",1,0)) AS [# Actions Returned],
Sum(IIf(Status="Pending",1,0)) AS [# Actions Pending],
Sum(IIf(Status="Solicited",1,0)) AS [# Actions Solicited],
Sum(IIf(Type="Mod",1,0)) AS [# MOD Actions],
Sum(IIf(Status="Awarded",1,0)) AS [# Actions Awarded],
Sum(IIf(CAR_Final="No",1,0)) AS [# Overdue CARS],
Sum(IIf(Award_Date>=Date_Rec,Award_Date-Date_Rec)) AS daystoaward,
Sum(IIf(Complete="Yes",1,0)) AS Awarddays,
Sum(IIf(Type="Mod",1,0)) AS MOD,
Sum(IIf(Type="Supplies",1,0)) AS Supplies,
Sum(IIf(Type="Construction",1,0)) AS Construction,
Sum(IIf(Type="Utilities",1,0)) AS Utlities,
Sum(IIf(Type="A&E",1,0)) AS [A and E],
Sum(IIf(Type="Services",1,0)) AS Services,
Sum(IIf(Date_Rec<Date()-30 And complete="No",1,0)) AS daysoverdue,
Sum(Nz([PR_$_Value])) AS [$ Value]
FROM
;
data type mismatch in criteria expression. Could someone please assist?
Thanks,
Lee
SELECT
Sum(IIf(Assigned,1,0)) AS [Cumulative Actions],
Sum(IIf(Status="Returned",1,0)) AS [# Actions Returned],
Sum(IIf(Status="Pending",1,0)) AS [# Actions Pending],
Sum(IIf(Status="Solicited",1,0)) AS [# Actions Solicited],
Sum(IIf(Type="Mod",1,0)) AS [# MOD Actions],
Sum(IIf(Status="Awarded",1,0)) AS [# Actions Awarded],
Sum(IIf(CAR_Final="No",1,0)) AS [# Overdue CARS],
Sum(IIf(Award_Date>=Date_Rec,Award_Date-Date_Rec)) AS daystoaward,
Sum(IIf(Complete="Yes",1,0)) AS Awarddays,
Sum(IIf(Type="Mod",1,0)) AS MOD,
Sum(IIf(Type="Supplies",1,0)) AS Supplies,
Sum(IIf(Type="Construction",1,0)) AS Construction,
Sum(IIf(Type="Utilities",1,0)) AS Utlities,
Sum(IIf(Type="A&E",1,0)) AS [A and E],
Sum(IIf(Type="Services",1,0)) AS Services,
Sum(IIf(Date_Rec<Date()-30 And complete="No",1,0)) AS daysoverdue,
Sum(Nz([PR_$_Value])) AS [$ Value]
FROM