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

  • Thread starter Thread starter k. cason
  • Start date Start date
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
 
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.
 
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
 
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!!!!
 
Back
Top