ok, i have a database. i have a field named type. i have two other fields name processor and make/model. now if the type field value is "desktop" then i don't want to print the make/model field. if the type field value is "laptop" then i don't want to print the processor field. please help.

SELECT Type, IIF ( Type = "LapTop" , " " , [Processor]) AS Processor1, IIF ( Type = "DeskTop" , " " , [Make/Model]) AS [Make/Model1]
FROM
myTable;