Rounding down

[Tony Williams]

Is there any way to force Access to round down figures. eg I'm using this
formula
=Round([Sum Of txtDomfactot],0)
but I want the rounding to be always downwards eg I want 13.567 to be shown
as 13 no 14
Anyone help?
Thanks
Tony

 

[strive4peace]

try
Int([Sum Of txtDomfactot])

this will truncate the decimal portion of the number

if you have negative numbers, you may want to use

Fix([Sum Of txtDomfactot])

from Help:
---------------------
Both Int and Fix remove the fractional part of number and
return the resulting integer value.

The difference between Int and Fix is that if number is
negative, Int returns the first negative integer less than
or equal to number, whereas Fix returns the first negative
integer greater than or equal to number. For example, Int
converts -8.4 to -9, and Fix converts -8.4 to -8.

Fix(number) is equivalent to:

Sgn(number) * Int(Abs(number))
---------------------


Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*

 

[Tony Williams]

Thanks I'll try that
Tony

try
Int([Sum Of txtDomfactot])

this will truncate the decimal portion of the number

if you have negative numbers, you may want to use

Fix([Sum Of txtDomfactot])

from Help:
---------------------
Both Int and Fix remove the fractional part of number and return the
resulting integer value.

The difference between Int and Fix is that if number is negative, Int
returns the first negative integer less than or equal to number, whereas
Fix returns the first negative integer greater than or equal to number.
For example, Int converts -8.4 to -9, and Fix converts -8.4 to -8.

Fix(number) is equivalent to:

Sgn(number) * Int(Abs(number))
---------------------


Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*

Is there any way to force Access to round down figures. eg I'm using this
formula
=Round([Sum Of txtDomfactot],0)
but I want the rounding to be always downwards eg I want 13.567 to be
shown as 13 no 14
Anyone help?
Thanks
Tony

 

[strive4peace]

you're welcome, Tony happy to help

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*

Thanks I'll try that
Tony

try
Int([Sum Of txtDomfactot])

this will truncate the decimal portion of the number

if you have negative numbers, you may want to use

Fix([Sum Of txtDomfactot])

from Help:
---------------------
Both Int and Fix remove the fractional part of number and return the
resulting integer value.

The difference between Int and Fix is that if number is negative, Int
returns the first negative integer less than or equal to number, whereas
Fix returns the first negative integer greater than or equal to number.
For example, Int converts -8.4 to -9, and Fix converts -8.4 to -8.

Fix(number) is equivalent to:

Sgn(number) * Int(Abs(number))
---------------------


Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*

Is there any way to force Access to round down figures. eg I'm using this
formula
=Round([Sum Of txtDomfactot],0)
but I want the rounding to be always downwards eg I want 13.567 to be
shown as 13 no 14
Anyone help?
Thanks
Tony