The largest number I can show with the Long Integer field size seems to be 2100000000.
I need it to show 2500000000. How can I accomplish this??????
The largest number I can show with the Long Integer field size seems to be 2100000000.
I need it to show 2500000000. How can I accomplish this??????
From VBA Help!
Long Data Type
Long (long integer) variables are stored as signed 32-bit (4-byte) numbers ranging in value from -2,147,483,648 to 2,147,483,647.
Thank you for your help.
I needed it to hold a number larger than 2.2 Billion.
By changing the field size to Double instead of Long Integer, I was able to accomplish that.
Thanks again.
Glad to hear you got it sorted.