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

los decimals

Status
Not open for further replies.
TIPtip

TIPtip

Programmer
Joined
Jan 5, 2004
Messages
9
Location
SI


val(NZ(
.[field],0))
returns zero 0

then i calculate : 0 - 123.44 and returns -123 and i lost 0.44.

How to handle this?
 
Sort by date Sort by votes
what is the datatype of the variable you are assigning the result of the subtraction?
 
Upvote 0 Downvote
in table a field is Double, format standard and decimal places 2

i have this calculating in qwey
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

radder33
  • Locked
  • Question Question
Calculation not showing decimals correctly
Replies
2
Views
312
kjv1611
kjv1611
chainedtodesk
  • Locked
  • Question Question
trim field with multiple decimals
Replies
2
Views
162
chainedtodesk
chainedtodesk
fishtek
  • Locked
  • Question Question
Extracting whole numbers and decimals from text field
Replies
2
Views
125
fishtek
fishtek
hotbread
  • Locked
  • Question Question
Union query causes average field decimals to be truncated or rounded
Replies
3
Views
155
TheAceMan1
TheAceMan1
Twinmammy
  • Locked
  • Question Question
losing decimal when loading to MS access
Replies
9
Views
408
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top