What is the Difference between IIF & SWITCH ? Thanks in Advance.. Srid Malt

http://technet.microsoft.com/en-us/library/ms157328.aspx The Iif function returns one of two values depending on whether the expression is true or not. The following expression uses the Iif function to return a Boolean value of True if the value of LineTotal exceeds 100. Otherwise it returns False: The Switch function is useful when you have three or more conditions to test. The Switch function returns the value associated with the first expression in a series that evaluates to true:Sergei