Could you use another IIf function designating employee type conditions and then wrap that around your exisiting IIf function? Jim --- In [email protected], "torres0157" <[EMAIL PROTECTED]> wrote: > Good Morning, > I have a calculated field ComPct on a Form created in a query. > ComPct: IIf([GrossBilling]>0,Format([ComNo]* [ComPctAmt],"#.###"),0). > This Calculated (ComPct) can have various Decimal Places. Depending > on the Employee type. I there a function in access that I can > use to increase the decimal Positions to the results field depending > depending on the value of another field. > > Thanks A.T.
------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12h2od7cq/M=362335.6886445.7839731.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123527022/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http://groups.yahoo.com/";>In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide!</a>.</font> --------------------------------------------------------------------~-> 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/
