# sign added to end of value

[arage]

# sign added to end of value
When I type:

tempSAP = 60614907704

I get this instead:

tempSAP = 60614907704#

Could someone explain please?

 

[pdx_man]

What is the DataType of tempSAP? The # symbol in this case usually means that the value on the right hand side is converted to a DataType Double.

 

[arage]

its type long integer

 

[Drevlin]

Your number is too long for a long integer.
Long Int Range is -2,147,483,648 to 2,147,483,647


Try using Single or Double instead of Long.
Access will still place the # sign after your number but the sign won't be passed to the variable. If you had tried to run your sub it should have given you an Overflow error. This just means the number won't fit inside of your variable.

Peace

 

[pdx_man]

Uh, Yup!

 

[ritchieroo]

TIP: If you need to do any maths with very large integers, use the Currency data type. Unlike double and single, currency is fixed-precision, so you can avoid floating-point errors.

Range: -922,337,203,685,477.5808 to 992,337,203,685,477.5807