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

round up when capturing numbers to 2 decimals

Status
Not open for further replies.
nqobile

nqobile

Programmer
Aug 9, 2002
20
SZ
Each time i enter a number with 2 decimal places it is rounded up and I would not like this to happen. any suggestions on how I can keep the number as is???
 
Sort by date Sort by votes
Set the field type to Number - Double or Single and Number of decimals: Auto or 2.

Regards,

Dan

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
Can Access be used to generate and respond to text messages? 1
Replies
6
Views
636
TheresAlwaysAWay
TheresAlwaysAWay
renigar
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
368
renigar
renigar
v5652
  • Locked
  • Question
Ribbon icons missing each time when MS Windows 10 update
Replies
0
Views
148
v5652
v5652
Moss100
  • Locked
  • Question
Upgrading from Access 2013 - whats the best option
Replies
2
Views
536
Moss100
Moss100
lmcate
  • Locked
  • Question
How to Open ACCESS (MDB) from an HTML Page 1
Replies
2
Views
573
lmcate
lmcate

Part and Inventory Search

Sponsor

Back
Top