I have an Access query with the following clause:
Max(IIf([dbo_AbsDrgDiagnoses]![DiagnosisSeqID]=1,[dbo_AbsDrgDiagnoses]![Diagnosis],0)) AS PrinDiag
I have translated it to SQL as:
MAX(iif(dbo.AbsDrgDiagnoses.DiagnosisSeqID=1,dbo.AbsDrgDiagnoses.Diagnosis,0)) as PrinDiag
I am getting a syntax error that "error in list of function arguaments: "=" not recognized
Do you see what could be wrong?