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!

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

Number Field Wont Stop Rounding Off Numbers with Decimals 1

Status
Not open for further replies.
Kjonnnn

Kjonnnn

IS-IT--Management
Jul 14, 2000
1,145
US
I've changed and played with all the number properties but when I add a number to the table with a decimal (34.69) it rounds it up or down?

Even if i choosed a fix decimal place under Format. It rounds off and display two zeros.

Any ideas?
 
Sort by date Sort by votes
make sure that ur field size is not set to integer...chagne it to double it should fix the probelm
 
Upvote 0 Downvote
Thank you VERY MUCH ... that worked.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Field size limit Access 365
Replies
5
Views
3K
TrekBiker
TrekBiker
JayRo71
  • Locked
  • Question
Saved Imoorts problem with file name
Replies
10
Views
500
Andrzejek
Andrzejek
monkeysee
  • Locked
  • Question
Field to count specific records
Replies
3
Views
365
dhookom
dhookom
Anthony343242
  • Locked
  • Question
MS ACCESS UNION ALL with Attachment data type 1
2
Replies
29
Views
4K
Anthony343242
Anthony343242
Lidias13
  • Locked
  • Question
Odata contains fields from multiple tables in single table with different field names - for same
Replies
1
Views
333
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top