Iif() only works in Access. I assume that you're using SQL Server. In that case, you need to use the CASE construct. Search Books on Line (BOL) for details.

Arthur