Yes, I have for a total of 4 formats to display on the form. How many IIf statements can I use.
--- In AccessDevelopers@yahoogroups.com, "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 AccessDevelopers@yahoogroups.com, "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=12hg2srct/M=362329.6886308.7839368.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123527951/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992 ">Fair play? Video games influencing politics. Click and talk back!</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/
