Good Morning,
I need some help in changing my condition statement
Commission: IIf([GrossBilling]/[ListAmount]>=1,1,
IIf([GrossBilling]>0,Format([GrossBilling]/[ListAmount],
"#.##),0)))
I need to insert some extra conditions to check if Commision
= zero to insert 0.00. [GrossBilling]/[ListAmount]=0,0.
I tried but to no avail. I am still trying.
Can someone Help...
Thanks A.T.
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
