#error sintax when trying to add sum+iif

T

thread

hi all,
i'm trying to make a sum calculation in the form and im getting
error,the starting sintax is as follow:
=sum(IIF(...,1,0))
what should be the problem?
 
S

strive4peace

the error must be in the part of the equation you are not
showing ... are you using the NAME property of the controls
that you are referencing?

where are you putting this equation?

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*
 
T

thread

hi,
thanks for you answer but i found the problem,the computer do not know
how to indentify when he is getting data from query+data from form

strive4peace כתב:
 
S

strive4peace

you're welcome :) glad you got it!

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*
 
Top