#error sintax when trying to add sum+iif

  • Thread starter Thread starter thread
  • Start date Start date
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?
 
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

*
 
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 כתב:
 
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

*
 
Back
Top