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

Decimal Place problem

Status
Not open for further replies.

Wrecker

Technical User
Aug 29, 2001
126
US
I have the Properties for a field in a table set to:
Field Size: Double
Format: General Number
Decimal Places:2

I also have the properties in the textbox for the field, set to general number, and 2 Decimal places.

My calculation keeps coming back with many decimal places.
How do I get a return of only 2 decimal places?
Any suggestions would be appreciated
Thanks
Wrecker
 
If you change the format to Fixed you can still retain the actual value entered but use the Round function to display the number with only 2 decimals. Ann
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top