Hi,

I am having difficulty capturing the decimal values in my result.

For example,

If the value is divisible by a constant let’s say (16/16 = 1.0 or 32/16 = 2.0 or 48/16 = 3.0 etc...) then I need to ignore the record and if the value is not divisible by the constant and I get decimal values like (20/16 = 1.25 or 100/16 = 6.25 or 500/16 = 31.25) then I need to capture this value. I only need to capture when there is a reminder value with decimals.

Please let me know if anyone has some idea?

Thanks.

Look in the Functions Manual, Numeric functions section for:

DMOD, FMOD, and IMOD: Calculating the Remainder From a Division

If your remainder is 0 you will use a WHERE to exclude the row. If the remainder is not 0 then you keep the row.

Thank you PIIPSTER.