Rounding Problem

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!)
 
A Long Integer can't have decimal places. Change it to Single or Double.
 
thanks, it worked! ;)
 

Users who are viewing this thread

Back
Top Bottom