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

Access keeps rounding my decimal numbers

Status
Not open for further replies.
3239

3239

Technical User
Joined
May 14, 2003
Messages
64
Whenever I enter a decimal number into a table, Access rounds the number. How could I prevent this from happening?
 
Sort by date Sort by votes
Hi,

What is the data type of your field?

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question Question
Field size limit Access 365
Replies
5
Views
6K
TrekBiker
TrekBiker
Anthony343242
  • Locked
  • Question Question
MS ACCESS UNION ALL with Attachment data type
2
Replies
29
Views
9K
Anthony343242
Anthony343242
BugZap13
  • Locked
  • Question Question
How to extract Access table schema with decimal places on numeric fields?
Replies
2
Views
5K
dhookom
dhookom
LauraW
  • Locked
  • Question Question
Leading Spaces in Access Database
Replies
18
Views
2K
Andrzejek
Andrzejek
teach314
  • Locked
  • Question Question
In my code, I create and fill a tab
Replies
1
Views
320
teach314
teach314

Part and Inventory Search

Sponsor

Back
Top