Thanks much, Lava. The Abs function works. Jim
--- In [email protected], "Lava Boggavarapu" <[EMAIL PROTECTED]> wrote: > You may want to use the mod or absolute value function. > > > > Lava > > > > ------------------------------------------------ > > Lava Boggavarapu > > Lava Trading Inc. > > 95 Morton Street, 6th Floor > > New York, NY 10014 > > Tel 212.519.9371 > > Fax 212.519.9283 > > Mobile 732.668.2935 > > www.lavatrading.com > > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of jmw95823 > Sent: Monday, August 22, 2005 2:54 PM > To: [email protected] > Subject: [AccessDevelopers] Need Number Formatting Help, Please. > > > > I have a calculated field. If the value is a negative currency > amount, I want to show it as positive. Any help is appreciated. > Thanks. Jim > > > > > > > Please zip all files prior to uploading to Files section. > > > > > ________________________________ > > YAHOO! GROUPS LINKS > > > > * Visit your group "AccessDevelopers > <http://groups.yahoo.com/group/AccessDevelopers> " on the web. > > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED] subject=Unsubscribe > > > > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of > Service <http://docs.yahoo.com/info/terms/> . > > > > ________________________________ > > > > The information contained in this message and any attachments (the "Message") is intended for specific individual(s), and may be confidential or proprietary. If you are not the intended recipient, please notify the sender immediately, delete this Message and do not disclose. Messages are not secure or error free and can contain viruses and the sender is not liable for any of these occurrences. The sender reserves the right to monitor, record and retain Messages. ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12he79egn/M=362131.6882499.7825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1124746165/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org ">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life - brought to you by One Economy</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/
