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 2

Status
Not open for further replies.

itauditor

Technical User
Jan 8, 2001
16
US
How do I prevent my numbers from rounding in tables, forms, and reports? I have specified standard format with 1 decimal place. However, Access keeps rounding up/down and giving me a 0 for all decimals...
 
You will have to go back to each and every reference for them to make sure that all formats are set correctly. Also, review the actual table that is calling them to make sure the data is in it correctly.

Larry
 
Hi,

I had the same problem with rounding numbers even after checking all the properties in my forms and tables. You might also want to try changing the field size for your number field from Long Integer (if that is what it is set at) to Single or Double in the property settings on the original table. Single or Double allows for a more precise decimal setting.

Hope this helps!

TASH

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top