int vs. cint?

[ExcessAccess]

What is the difference between:
iif([fieldname]<0,0,cint([fieldname]))
and
iif([fieldname]<0,0,int([fieldname]))
Thanks in advance for any clarification!

~J

 

[Brian Camire]

CInt returns an Integer variable. Values of Integer variables are limited
to the range from -32,768 to 32,767. So, for example, CInt(32768.1) will
return cause an overflow run-time error.

Int returns a Double variable. Doubles have a much (much, much) larger
range, from -1.79769313486231E308 to 1.79769313486232E308. So, for example,
Int(32768.1) returns 32678.

Also, CInt does not accept a Null argument, but Int does (in which case it
returns Null).

 

[John Spencer (MVP)]

PLUS CInt rounds numbers with decimal portion, while Int returns the number that
is the next smallest integer. Strip the decimal portion for Positive numbers
and for negative numbers gives the next number to the left on the number line.
Fix is similar but slightly different. Positives and negatives basically drop
the decimal portion.

Int(-5.25) returns -6; Int(5.25) returns 5

CInt returns an Integer variable. Values of Integer variables are limited
to the range from -32,768 to 32,767. So, for example, CInt(32768.1) will
return cause an overflow run-time error.

Int returns a Double variable. Doubles have a much (much, much) larger
range, from -1.79769313486231E308 to 1.79769313486232E308. So, for example,
Int(32768.1) returns 32678.

Also, CInt does not accept a Null argument, but Int does (in which case it
returns Null).

What is the difference between:
iif([fieldname]<0,0,cint([fieldname]))
and
iif([fieldname]<0,0,int([fieldname]))
Thanks in advance for any clarification!

~J