IF FUNCTION

  • Thread starter Thread starter kumars
  • Start date Start date
I WANT TO MAKE FORMULA IN ACCESS USING IF FUNCTION IN ACCESS UPTO THREE
OPTIONS
Click to expand...

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
 
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
 
Back
Top