E
Eve
I know how to create an "If, Then" statement in Excel,
but I forget the syntax for Access!
but I forget the syntax for Access!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
E
Eve
Thank you!!
I remembered that it was something silly, why in the
world do they add an extra i ???????? It's crazy, they
should keep it consistent with Excel, don't you think?
I remembered that it was something silly, why in the
world do they add an extra i ???????? It's crazy, they
should keep it consistent with Excel, don't you think?
J
Joe Harman
IIF means "immediate if". The functions in Access (and
VB/VBA) seem to me to be more consistent with other
programming constructs than Excel.
VB/VBA) seem to me to be more consistent with other
programming constructs than Excel.
J
Jeff Boyce
Eve
If you code in VBA, you'll see that the "If ... Then" statement works. The
Immediate If (IIF()) function works inside queries.
Jeff Boyce
<Access MVP>
If you code in VBA, you'll see that the "If ... Then" statement works. The
Immediate If (IIF()) function works inside queries.
Jeff Boyce
<Access MVP>
J
John Spencer (MVP)
Because it is an Immediate IF and is a different function from If...Then...End
If. Since it is a different function, it must have a different name.
If. Since it is a different function, it must have a different name.