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

IFF function in access 2007: undefined function, why?

P: n/a
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
Jan 3 '08 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Jan 2, 7:10*pm, kasparov11 <212mari...@gmail.comwrote:
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?
Jan 3 '08 #2

P: n/a
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/For...ccess/200801/1

Jan 3 '08 #3

P: n/a
kasparov11 <21********@gmail.comwrote in news:6abee428-5c5c-4856-
b1***************@u10g2000prn.googlegroups.com:
On Jan 2, 7:10*pm, kasparov11 <212mari...@gmail.comwrote:
>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

Jan 3 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.