Question: how to do iif function in access?
Answer: You can use the iif function in a query in Microsoft Access. In this example, if the [Time Out] field is less than or equal to 12 o'clock noon, then the iif function will return the number of hours that have elapsed between [Time Out] and [Time In].