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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Turn Rounding Off

Status
Not open for further replies.

Cpreston

MIS
Mar 4, 2015
972
GB
Hi

I have a problem trying to get rid of rounding on a field. Th actual figure I am expecting to see is 7.986 but the field is coming in as 8.

I have tired to change the settings under customise and number but cannot get it to show the actual figure coming form the database, in this case 7.986

Any help please would be great, Thanks
 
Hi

Managed to solve it, for anyone else who may have this issue, Format the filed, Customise, Set Decimals to 1.000 and then set rounding to o.oo1

This then displayed 7.986

 
Sounds like you did not show enough decimal places (icon on tool bar).
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top