#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

*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum(iif(...)) Help 8
sum of two queries 6
Count - if statement.... 3
union query problem 16
Sum Iff Function 8
Access Query problem 1
Newbie, trouble with IIFstatement in SQL query 4
Aggregate Function Error 0

Top