If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#error sintax when trying to add sum+iif
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? |
#2
|
|||
|
|||
#error sintax when trying to add sum+iif
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 * thread wrote: 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? |
#3
|
|||
|
|||
#error sintax when trying to add sum+iif
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 כתב: 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 * thread wrote: 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? |
#4
|
|||
|
|||
#error sintax when trying to add sum+iif
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 * thread wrote: 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 כתב: 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 * thread wrote: 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? |
Thread Tools | |
Display Modes | |
|
|