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

[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

 

[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.

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.

 

[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

 

[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

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