Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Rounding Problem

Status
Not open for further replies.

Only1Abhi

Technical User
Jan 26, 2003
77
GB
Hi.

I have a 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!)
 
problem solved by turning Long Integer into Single.
Thanx anyways ppl!

(double will also work)!
 
if you use fixed it will always show the number of decimals specified even if they are .00
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top