Thanks, for all the input, I'm heading toward a new method due to changes by users.
A.T. --- In [email protected], "dreaux1" <[EMAIL PROTECTED]> wrote: > per AT > > > 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. > > I'm kinda new with ACCESS, but otherwise an old BASIC string > manipulator..... > > in its simplist situation that I can imagine ... > if you had 4 employee types > > 1,2,3,4 > > and wanted a different format for each employee > > #.#### > ##.### > ###.## > ####.# > > then ... > > IF t = EMPLOYEE TYPE > AND s = fORMAT > > s = mid$("#.####/##.###/###.##/####.#",1+((t-1)*7),6) > > it might get a bit more complicated with employee types of > "Labor" and "manager", etc. also if you have to guard against > blank or invalid employee types. > > Jeb ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12h3mle1o/M=362329.6886308.7839368.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123634378/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/
