Formula in my Query

  • Thread starter Thread starter Eve
  • Start date Start date
E

Eve

I know how to create an "If, Then" statement in Excel,
but I forget the syntax for Access!
 
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.
 
You must log in or register to reply here.

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
Case When statement in Access Frontend with Sql Backend 6
Union Query and Field Alias 7
IIf 1
access 2007 criteria in query 2
Pipe character in query in VB6 app 11

Back
Top