Hello All,
I'm looking at the following Access Query line:
Code:
HAVING (((IIf([QRY_003_Assoicates_JC_Overrides] ! [Sec_JobCode] ! [Role_Group] <> [QRY_003_Assoicates_JC_Overrides] ! [Sec_JobCode_1] ! [Role_Group], "Send", "Ignore")) = "Send"));
Here is my translation to SQL Server syntax:
Code:
HAVING casewhen [QRY_003_Assoicates_JC_Overrides] . [Sec_JobCode].[Role_Group] <> [QRY_003_Assoicates_JC_Overrides].[Sec_JobCode_1].[Role_Group]
then'send'else'Ignore'='Send';
editor does not like the "=" at the very end of the line. Any ideas what it should be there?
thanks,
Keith