Getting the remainder IMP

J

JoeGriffin

I need to get the remainder of a figure having a decimal point.
That is, lets say I have the following number :

2.5

I need to keep the .5 and remove the 2.

ANyone has any ideas how this is done.

Thanx.
 
A

Allen Browne

Try:
[MyField] - Fix([MyField])

Depending on your needs, choose Int() or Fix().
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top