I have just created a new access databse. In this two currency fields exist. The problem is however that Access rounds off the input.
I have tried the folowing to solve this
Entering the same in Excel. - No problem. The price is displayed correctly. This tells me that the problem is not in my regional settings (IMHO)
I've set the number of decimals to two. Now when I enter for example 2.4 it displays 2.00
Please help me out with this.
Erik Jan
I have tried the folowing to solve this
Entering the same in Excel. - No problem. The price is displayed correctly. This tells me that the problem is not in my regional settings (IMHO)
I've set the number of decimals to two. Now when I enter for example 2.4 it displays 2.00
Please help me out with this.
Erik Jan