Skip to content
Advertisement

Tag: iif

IIF statement to filter Access Query with checkbox

I’m working on a search form based off a single table. I’m working primarily in the query design view. I’d like to have a checkbox on the form so if it is checked (true) it will only return records where the setID is Null. If unchecked (false) it will return all records regardless of if there is a value in

Replacing case with IIF in SQL Server

So for my above query, I want to use IIF instead of CASE, because I want to show only uninsured patients, would something be correct? Because if I only use one case in my case scenario, the null will should up in my insurancestatus column instead of uninsured. Basically I just want the result for null showing up in result,

Advertisement