--- In [email protected], "torres0157" <[EMAIL PROTECTED]> wrote: > Yes, > I have for a total of 4 formats to display on the form. > How many IIf statements can I use. > > > --- In [email protected], "jmw95823" <[EMAIL PROTECTED]> > wrote: > > 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=12h1vc32t/M=362335.6886445.7839731.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123529365/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/
