Assistance Requested: Creating Expression Based on an IF-THEN Statement

K

k. cason

I have a simple question. Is it possible to create an
expression for records based on the result of a field
within the same record? I was unsuccessful at attempting
to create an IF-THEN statement. Please provide ideas as I
am a novice to Access.

Thanks!

-K
 
J

John Vinson

I have a simple question. Is it possible to create an
expression for records based on the result of a field
within the same record? I was unsuccessful at attempting
to create an IF-THEN statement. Please provide ideas as I
am a novice to Access.
Click to expand...

Yes, using the IIF() function:

IIF(<logical expression>, <value if true>, <value if false>)

e.g.

IIF([Income] > [Expenses], "Happy", "Worried")

If you'ld care to describe your table and what you want to do perhaps
someone could give a more specific answer.
 
H

HSalim

If you can provide us with more information then
We can help you
Else
we could guess. In Queries, try using IIF
end if

HS
 
J

John Vinson

If you can provide us with more information then
We can help you
Else
we could guess. In Queries, try using IIF
end if
Click to expand...

Laughing out loud... that's great!!!!
 
Top