Happy New Year to all! I am going through the courses here on Access Learning Center as fast as time will allow me. However, I have a question which I am sure will be covered at some point, but I sort of need to figure it out now as I am starting to build my database with very simple reports to get me started.

For anyone who has seen my other post, I work in the financial services sector. Mostly we only service large financial institutions so there are times when transactions can be quite large. For example, I may have a single US Treasuries trade for $30 million which normally would be represented as $30,000,000.00 which is no problem with the "Large Integer" format. However, I receive a data file each day from the markets and the bank that settles our trades between our buyer and seller.

The data I receive is in a "raw" format, and none of the amounts include decimal points so a $30 million trade imports as 3000000000 which is larger than the "Large Integer" format allows and I get errors when importing the data and the records are left blank.

How do I get around the "Large Integer" range limitations?

Thanks!

---

Reply from Alex Hedley:

You could sanitise the data before you import it, import it as a string, trim some decimals, if you don't need them then import to the table you need.
You could also use the Currency Field. It allows 15 digits, but that wouldn't help with decimals.
Maybe a format.

3000000000 => 10
2147483648 => 10

Integer Allows whole numbers between -32,768 and 32,767 2 bytes
Long Allows whole numbers between -2,147,483,648 and 2,147,483,647
Currency Use for currency. Holds up to 15 digits of whole dollars, plus 4 decimal places. Tip: You can choose which country's currency to use