Use an iif(). You can use it in an update, insert, or whatever.
Update MyTable
Set Change_Plan = iif(Valid_User="Y","N","OtherValueHere")
Where blah blah blah
Or the following will make no change if not appropriate.
Update MyTable
Set Change_Plan = iif(Valid_User="Y","N",[Change_Plan])
Where blah blah blah
-----Original Message-----
From: Conaway, Amy C [mailto:[EMAIL PROTECTED]
Sent: Monday, August 11, 2003 09:04
To: SQL
Subject: if statement?
Hi, I was wondering if there was any way to assign values to a record in
MS Access, similar I guess to an IF statement in other languages
IF Valid_User == 'y'
THEN Change_Plan = 'n'
Does that make any sense? Any other ideas for approaching this? Thx!
-amy
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6
Get the mailserver that powers this list at
http://www.coolfusion.com
