Return remainder value

Dear Sir,

How to code in VBA to return the remainder value? eg

Field1 = 20
Result = Field1 / 3
Field1 /3 = 6.66666 but I need the result value as 0.66666
Remainder = 0.66666

Please advice and thank you.
SK.Chow

Hello skchow,

Subtract the integer portion of the dividend from the dividend...

Please Login or Register  to view this content.

Sincerely,
Leith Ross