<div>
According to MSDN for SQL 2012, what you have should work for the new IIF function. &nbsp;But since it is not, give the CASE statement a try instead:<br />
<br />
SELECT (CASE WHEN dbo.AbsDrgDiagnoses.Diagno<wbr />sisSeqID = 1 THEN dbo.AbsDrgDiagnoses.Diagno<wbr />sis ELSE 0) as PrinDiag
</div>


According to MSDN for SQL 2012, what you have should work for the new IIF function.  But since it is not, give the CASE statement a try instead:

SELECT (CASE WHEN dbo.AbsDrgDiagnoses.DiagnosisSeqID = 1 THEN dbo.AbsDrgDiagnoses.Diagnosis ELSE 0) as PrinDiag

<div>
Thanks I forgot about the case statement
</div>


<div>
<div class="content wysiwyg-content">
I have an Access query with the following clause:<br />
<br />
Max(IIf([dbo_AbsDrgDiagnos<wbr />es]![Diagn<wbr />osisSeqID]<wbr />=1,[dbo_Ab<wbr />sDrgDiagno<wbr />ses]![Diag<wbr />nosis],0))<wbr /> AS PrinDiag<br />
<br />
I have translated it to SQL as:<br />
<br />
MAX(iif(dbo.AbsDrgDiagnose<wbr />s.Diagnosi<wbr />sSeqID=1,d<wbr />bo.AbsDrgD<wbr />iagnoses.D<wbr />iagnosis,0<wbr />)) as PrinDiag<br />
<br />
I am getting a syntax error that &quot;error in list of function arguaments: &quot;=&quot; not recognized<br />
<br />
Do you see what could be wrong?<br />
<br />
Thanks<br />
<br />
Glen
</div>
</div>


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?

Thanks

Glen

MAX and IIF statements Access vs SQL

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.