Decimal number ??

  • Thread starter Thread starter MJJ
  • Start date Start date
M

MJJ

I have a variable that is either going to be some whole #
or some whole # +.5 i.e. 40 or 40.5, 35 or 35.5

Is there a way to get rid of that decimal pt w/o rounding?

i.e. 41.5 becomes 41 etc, etc.

Thanks
 
-----Original Message-----
You can use
Int([YourVariable])

--
Duane Hookom
MS Access MVP


I have a variable that is either going to be some whole #
or some whole # +.5 i.e. 40 or 40.5, 35 or 35.5

Is there a way to get rid of that decimal pt w/o rounding?

i.e. 41.5 becomes 41 etc, etc.

Thanks
Click to expand...


.
Thanks! Is there any function to determine if there is
Click to expand...
anything after the decimal?
 
DecimalValue = OriginalNumber - Int(OriginaNumber)


--

Ken Snell
<MS ACCESS MVP>

MJJ said:
-----Original Message-----
You can use
Int([YourVariable])

--
Duane Hookom
MS Access MVP


I have a variable that is either going to be some whole #
or some whole # +.5 i.e. 40 or 40.5, 35 or 35.5

Is there a way to get rid of that decimal pt w/o rounding?

i.e. 41.5 becomes 41 etc, etc.

Thanks
Click to expand...


.
Thanks! Is there any function to determine if there is
Click to expand...
anything after the decimal?
Click to expand...
 
Back
Top