IFF function in access 2007: undefined function, why?

#1

kasparov11 <212marines (AT) gmail (DOT) com> wrote in news:6abee428-5c5c-4856-
b1c6-2a60f00ae63a (AT) u10g2000prn (...oglegroups.com:

Quote:

On Jan 2, 7:10*pm, kasparov11 <212mari... (AT) gmail (DOT) 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

#2

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

#3

On Jan 2, 7:10*pm, kasparov11 <212mari... (AT) gmail (DOT) com> 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

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?

#4

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

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

IFF function in access 2007: undefined function, why?

comp.databases.ms-access comp.databases.ms-access

Re: IFF function in access 2007: undefined function, why? - 01-02-2008 , 09:35 PM

IFF function in access 2007: undefined function, why? - 01-02-2008 , 10:10 PM

Re: IFF function in access 2007: undefined function, why? - 01-02-2008 , 10:19 PM

Re: IFF function in access 2007: undefined function, why? - 01-02-2008 , 10:25 PM