IIF statement in query field name expression builder

[sbowman]

I'm trying to get a query in access to give me a parsed string if the
field contents are not null and the value from another field if the
field contents are null. I have the following in the expression
builder:

ADID: iff([User Logon Name]<>"",
(Left$([User Logon Name],InStr(1,[User Logon Name],"@")-1)),
([Pre-Windows 2000 Logon Name]))

I keep getting the error "undefined function 'iff' in expression"

It's been a looooooong time since i've dealt with Access...please take
pity on me!!

Thanks,
Shelley

[pietlinden]

ADID: iff([User Logon Name]<>"",
(Left$([User Logon Name],InStr(1,[User Logon Name],"@")-1)),
([Pre-Windows 2000 Logon Name]))

It's IIF, not IFF... try that and you should be good to go.

[fredg]

On 3 Aug 2006 12:51:00 -0700, sbowman wrote:

I'm trying to get a query in access to give me a parsed string if the
field contents are not null and the value from another field if the
field contents are null. I have the following in the expression
builder:

ADID: iff([User Logon Name]<>"",
(Left$([User Logon Name],InStr(1,[User Logon Name],"@")-1)),
([Pre-Windows 2000 Logon Name]))

I keep getting the error "undefined function 'iff' in expression"

It's been a looooooong time since i've dealt with Access...please take
pity on me!!

Thanks,
Shelley

The function is IIF (not IFF).

Also, there is a difference between Null and "".

ADID:IIf(Not IsNull([User Logon Name]),Left([User Logon
Name],InStr(1,[User Logon Name],"@")-1),
[Pre-Windows 2000 Logon Name])
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[David W. Fenton]

fredg <fg******@example.invalidwrote in
news:13******************************@40tude.net:

The function is IIF (not IFF).

The reason for that is that it stands for Immediate If.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/