IF FUNCTION

[kumars]

I WANT TO MAKE FORMULA IN ACCESS USING IF FUNCTION IN ACCESS UPTO THREE
OPTIONS

 

[John Vinson]

I WANT TO MAKE FORMULA IN ACCESS USING IF FUNCTION IN ACCESS UPTO THREE
OPTIONS

Please explain. Turn off the CAPS LOCK key when you do so - it's
impolite (like you're SHOUTING AT US) and hard to read. What "three
options"?

There is an Access function IIF which takes three arguments: a logical
expression which evaluates to TRUE or FALSE; a value to return if it's
TRUE; and a value to return if it's FALSE.

There are also other functions - Choose() and Switch() - which can be
used for multiple branches.

Without knowing what data you have or what you want to accomplish I
can't be sure which to suggest!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Rafeeq]

Also there is a Select Case Function, which allows you to use any number of
True or False Statements to enable an action or event