You're missing a closing quote on your Format (see
red).
Tom Oakes
Personal PC Consultants, Inc.
[EMAIL PROTECTED]
503.230.0911 (O)
402.968.6946 (C)
713.583.7091 (F)
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of torres0157
Sent: Tuesday, July 26, 2005 9:22 AM
To: [email protected]
Subject: [AccessDevelopers] Help with Conditional _expression_
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
- Visit your group "AccessDevelopers" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
