modifying criteria based on fields other than the one it's modifying (1 Viewer)

N

nova

Guest
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.
 

araskas

Registered User.
Local time
Today, 06:23
Joined
May 31, 2000
Messages
38
SELECT Type, IIF ( Type = "LapTop" , " " , [Processor]) AS Processor1, IIF ( Type = "DeskTop" , " " , [Make/Model]) AS [Make/Model1]
FROM
myTable;
 

Users who are viewing this thread

Top Bottom