Seperating Whole Numbers and Decimal Numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

StuJol - 18 Sep 2006 15:19 GMT

Using vb in access 2003 i end up with a value of 1.006

i need to get the 1 on its own and the 006 on its own. Is there a function
that will remove the numbers to the left of the decimal point and to the
right of the decimal point?

Reply to this Message

Douglas J. Steele - 18 Sep 2006 15:28 GMT

The Fix function will remove the decimal portion (there's also the Int
function. The difference is how they treat negative values: Int returns the
first negative integer less than or equal to the number, while Fix returns
the first negative integer greater than or equal to number).

Once you've got the integer part of the number, subtract it from the
original number to get the decimal portion.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Using vb in access 2003 i end up with a value of 1.006
>
> i need to get the 1 on its own and the 006 on its own. Is there a function
> that will remove the numbers to the left of the decimal point and to the
> right of the decimal point?

Reply to this Message

StuJol - 18 Sep 2006 16:01 GMT

Once Again, Many Thanks Douglas

> The Fix function will remove the decimal portion (there's also the Int
> function. The difference is how they treat negative values: Int returns the
[quoted text clipped - 9 lines]
> > that will remove the numbers to the left of the decimal point and to the
> > right of the decimal point?

Reply to this Message