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!
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
