Mod function for decimals

[krima]

Hi all,

I am trying to mod two decimal numbers but in VBA the result comes back as an integer instead of a decimal. For what I am doing it is very important to have the full remainder. Is there a funciton that does this?

Any help would be great.

Thanks


Kyle

fyi
I am using access 2003.

 

[Uncle Gizmo]

all you need do is divided the remainder by the devisor this will give you the decimal value, that's all a decimal is !!!

If you take a third for example, the correct way to write a third is 1/3 the decimal equivalent is 0.33333 recuring, so the first answer 1/3 is actually the best answer and it is more accurate in most cases.