Rounding Numbers

From: rikesh (rikesh_patel_at_website.com)
Date: 03/29/04 

Date: Mon, 29 Mar 2004 09:40:21 +0100

Hi

I have a report, with lots of numerical fields, and I can't get rid of the
decimals on the end of a number, I've used INT , TRUNCATE, FIX and nothing
seems to work!!!!

Any ideas, anyone? 

-- 
Kind Regards
Rikesh
(CR8.5-CR9.0/W2K/SQL2K)

Relevant Pages

  • Re: <= 0
    ... Int is a function to convert a value to its whole number part ... What if the data type has to be Double, Fixed, 4 Decimals? ... "The form control for UnitCount is Fixed with 0 decimal points. ...
    (microsoft.public.access.formscoding)
  • Re: How do I show only the whole number w/o eliminating four decim
    ... Actually if the OP needs to do this it is better to use TRUNC since ... INT will round down to the nearest integer, ... the decimals. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: How do I show only the whole number w/o eliminating four decim
    ... Good point Peo. ... INT will round down to the nearest integer, ... like -123,478.99 will return -123,479 with INT and -123,478 with TRUNC ... the decimals. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: RtlMoveMemory to read an integer from a file
    ... You can also use a BinaryReader's ReadInt32 or ReadInt16 method if you need ... to read an int. ... > *This will round to 0 decimals. ... > set decimals to (VariableDecimals) ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Displaying Issue while creating dynamic CStatic
    ... BOOL CSplashWnd::SetMessage(LPTSTR strMessage,int Left, int Top, int ... Your txtTest object is local, which means it and the HWND it wraps will ... get rid of the CWnd* cast and avoid unnecessary casts in general. ...
    (microsoft.public.vc.language)
Quantcast