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

Numbers rounding off

Status
Not open for further replies.
alman123

alman123

IS-IT--Management
Oct 7, 2004
5
US
ok. i have looked this up. nothing seems to work. in my report numbers are being rounded up. instead of 512.82 its 512.83. what can i do to stop this. i have tried using only two decimal places. also changing the field as double. whats wrong.
 
Sort by date Sort by votes
And what about something like this ?
Int(100 * var) / 100

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

lameid
  • Locked
  • Question
Office / Access 365 Trusted locations and GP
Replies
0
Views
329
lameid
lameid
meagain
  • Locked
  • Question
Negative numbers to Bracketed text 1
Replies
2
Views
129
meagain
meagain
N2Life
  • Locked
  • Question
Graph too small in Office 365 Access
Replies
0
Views
201
N2Life
N2Life
arpeggione
  • Locked
  • Question
"Updates Available" banner - disable Updates not working - Office 2016
Replies
1
Views
158
Darrylles
Darrylles
Moss100
  • Locked
  • Question
Lookups in tables and combos on forms - column numbers 1
Replies
4
Views
118
1DMF
1DMF

Part and Inventory Search

Sponsor

Back
Top