By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,451 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

iif

P: n/a
im doing a sql statement in access and have to do an if in it and
found out that the function for if is iif
dose anyone know why this function is spelt with 2 i's ?

Jun 1 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
da********@gmail.com wrote:
im doing a sql statement in access and have to do an if in it and
found out that the function for if is iif
dose anyone know why this function is spelt with 2 i's ?
Immediate-If
IIf(SomeTest, Value if True, Value if False)

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Jun 1 '07 #2

P: n/a
On Fri, 1 Jun 2007 06:40:15 -0500, "Rick Brandt"
<ri*********@hotmail.comwrote:

So this is an in-line IF statement. Unlike VBA, in SQL you cannot
write:
if SomeTest then
Value if True
else
Value if False
end if
The next best thing is to use iif, and its related Choose function.

Of course in your SQL you can call a VBA function you wrote, that uses
a standard IF.

-Tom.

>da********@gmail.com wrote:
>im doing a sql statement in access and have to do an if in it and
found out that the function for if is iif
dose anyone know why this function is spelt with 2 i's ?

Immediate-If
IIf(SomeTest, Value if True, Value if False)
Jun 1 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.