Top "Iif" questions

How to encapsulate IIF and ISNULL call in Access 2010 VBA?

I use the following expression pattern in my Access 2010 database frequently: IIF(ISNULL(fieldName), Null, myFunction(fieldName)) Here myFunction is …

ms-access vba isnull iif

Incorrect syntax near '<'

I have a task to get some code which is working correctly on SQL Server 2012 to work on SQL Server 2008 …

sql-server tsql sql-server-2012 sql-server-2008-r2 iif

IIF 'Incorrect syntax near' error at SQL Server 2014

I am trying date control by month with this script DECLARE @Date DATETIME = '2015-07-31'; DECLARE @MonthCount INT = 3; …

sql sql-server-2014 iif

In an IIf function in Access, how do I assign null values?

I'm creating a calculated field (Field3) in a query in MS Access. In this example, Field2 contains both numeric and …

ms-access null calculated-field iif

Dynamically change the font size of a single character in SSRS

Using SSRS in Visual Studio 2012 I currently have the following expression in the report header. =ReportItems!FirmName.Value This correctly …

ssrs-2012 iif