You can try this. SET DECIMALS TO 1 more than you're formatting, in your case 3. Then use TRANSFORM(your number,"99999999999999999.99") to get it as a string. As long as the SET DECIMAL is at least 1 more than you're formatting to, it will truncate, not round.
Fred On Tue, May 4, 2010 at 3:00 PM, Tina Currie <[email protected]> wrote: > Hi all, > > > > Hoping you can shed some light for me. I've got a calculation that I'm > doing over 4 fields and then I convert the result to character by applying > STR() function - doing this to a length of 20 and decimal places of 2. > This > rounds UP my result. I don't want this to happen. Just want it to give me > the result to 2 decimal places. > > > > Is this possible in Fox? > > > > TIA, > > > > Tina > > > > > > > > > > > > > > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
