Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-31-2001, 10:28 AM   #1
nova
Guest
 
Posts: n/a
modifying criteria based on fields other than the one it's modifying

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.

  Reply With Quote
Old 11-16-2001, 02:31 PM   #2
araskas
Registered User
 
Join Date: May 2000
Posts: 38
Thanks: 0
Thanked 0 Times in 0 Posts
araskas
SELECT Type, IIF ( Type = "LapTop" , " " , [Processor]) AS Processor1, IIF ( Type = "DeskTop" , " " , [Make/Model]) AS [Make/Model1]
FROM
myTable;


araskas is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 11:07 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World