The IIF is an inline IF statement so the expression I provided says, if the value for the parameter is empty then don't bother adding that parameter to the query being passed to SQL server, but if it is not pass the value of the parameter to the SQL Server.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question