Only1Abhi
World Filled With Love
- Local time
- Today, 11:10
- Joined
- Jan 26, 2003
- Messages
- 99
Hi.
I have a table with lots of fields, but 2 in particular.
In Table Design View, I have set these 2 fields to Long Integer field size, General Number format, 2 decimal places, default value 0, NOT indexed, NOT required.
But when I type a value in the table in these 2 fields (or in the form I made linked to this table), If I type something like 75.75, It always ROUNDS to 76.
I NEED to keep the 2 decimal places. What has gone wrong?
(many thanks!)
I have a table with lots of fields, but 2 in particular.
In Table Design View, I have set these 2 fields to Long Integer field size, General Number format, 2 decimal places, default value 0, NOT indexed, NOT required.
But when I type a value in the table in these 2 fields (or in the form I made linked to this table), If I type something like 75.75, It always ROUNDS to 76.
I NEED to keep the 2 decimal places. What has gone wrong?
(many thanks!)