Formula in my Query

  • Thread starter Thread starter Eve
  • Start date Start date
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?
 
IIF means "immediate if". The functions in Access (and
VB/VBA) seem to me to be more consistent with other
programming constructs than Excel.
 
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>
 
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

Similar Threads

Calling Parameterized Query Using SQL Syntax 3
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
IF ISNUMBER FIND in query design expression 1
Union Query and Field Alias 7
Case When statement in Access Frontend with Sql Backend 6
IIf 1
access 2007 criteria in query 2
DSum in Query 3

Back
Top