Re: IFF function in access 2007: undefined function, why?

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

> On Jan 2, 7:10 pm, kasparov11 <212mari...@gmail.com> wrote:
>> 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?
>

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?

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

Re: IFF function in access 2007: undefined function, why?

On Jan 2, 7:10=A0pm, kasparov11 <212mari...@gmail.com> wrote:
> hello I am trying to use the iff function in a textbox in a report
> like such: =3DSum(if([prospdate]=3D[month1],[tcs],0))
> but I get an error undefined function.
>
> Kaspa

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

Re: IFF function in access 2007: undefined function, why?

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

John


kasparov11 wrote:
>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/Forums.aspx/databases-ms-ac cess/200801/1