Formula in my Query

E

Eve

I know how to create an "If, Then" statement in Excel,
but I forget the syntax for Access!
 
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?
 
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.
 
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>
 
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.
 

Ask a Question

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.

Ask a Question

Top