IFF function in access 2007: undefined function, why?

#1 January 3rd, 2008, 02:15 AM

hello I am trying to use the iff function in a textbox in a report
like such: =Sum(if([prospdate]=[month1],[tcs],0))
but I get an error undefined function.

Kaspa

#2 January 3rd, 2008, 02:25 AM

On Jan 2, 7:10*pm, kasparov11 <212mari...@gmail.comwrote:

Quote:

hello I am trying to use the iff function in a textbox in a report
like such: =Sum(if([prospdate]=[month1],[tcs],0))
but I get an error undefined function.
>
Kaspa

I meant =Sum(iff([prospdate]=[month1],[tcs],0)) I tried that too and
nothing works is this an 2007 issue? or am I missing a reference?

#3 January 3rd, 2008, 02:35 AM

The function you want is iif(), not iff()

John

kasparov11 wrote:

Quote:

>hello I am trying to use the iff function in a textbox in a report
>like such: =Sum(if([prospdate]=[month1],[tcs],0))
>but I get an error undefined function.
>
>Kaspa

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200801/1

#4 January 3rd, 2008, 02:35 AM

kasparov11 <212marines@gmail.comwrote in news:6abee428-5c5c-4856-
b1c6-2a60f00ae63a@u10g2000prn.googlegroups.com:

Quote:

On Jan 2, 7:10*pm, kasparov11 <212mari...@gmail.comwrote:

Quote:

>hello I am trying to use the iff function in a textbox in a

report

Quote:

>like such: =Sum(if([prospdate]=[month1],[tcs],0))
>but I get an error undefined function.
>>
>Kaspa

>
I meant =Sum(iff([prospdate]=[month1],[tcs],0)) I tried that too

and

Quote:

nothing works is this an 2007 issue? or am I missing a reference?
>

It is not IF() and it is not IFF()

The function is IIF()

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

IFF function in access 2007: undefined function, why?

Popular Articles

What is Bytes?