R
Randy
Access 2000. I have an expression in my query that 99% of the time will
give me the correct result, that is rounds up or down correctly. For
example, I am getting a result of .04 when I should be getting .05 The
actual number is .045 which should round up to .05 or .005 should round up
to .01 but I get .00. Here is the expression I am using as suggested from
an earlier posting. Help is appreciated, Thanks.
Round(-CInt(-[ExcMoisture]*[% In Kernels Rounded]),2)/100
Here are the two fields that are being referred to: ExcMoisture:
IIf([Moisture]>5,(-CInt(-[Moisture]*100)/100)-5,0) and
% In Kernels Rounded: IIf([Foreign Mat]<0.05,100-[% Edible Kern
Rounded],Int(([InedibleKernels]/[SampleSize])*10^4+0.5)/10^4*100)
give me the correct result, that is rounds up or down correctly. For
example, I am getting a result of .04 when I should be getting .05 The
actual number is .045 which should round up to .05 or .005 should round up
to .01 but I get .00. Here is the expression I am using as suggested from
an earlier posting. Help is appreciated, Thanks.
Round(-CInt(-[ExcMoisture]*[% In Kernels Rounded]),2)/100
Here are the two fields that are being referred to: ExcMoisture:
IIf([Moisture]>5,(-CInt(-[Moisture]*100)/100)-5,0) and
% In Kernels Rounded: IIf([Foreign Mat]<0.05,100-[% Edible Kern
Rounded],Int(([InedibleKernels]/[SampleSize])*10^4+0.5)/10^4*100)