Results 1 to 11 of 11

Thread: Negative Value not allowed

Hybrid View

  1. #1
    Join Date
    Jan 2009
    Location
    Portland, Oregon
    Posts
    21
    Do you just do not want negatives, or do you want it so you can't subtract more than is available?

    So, using the Abs function as Allan has said, would yield 7 instead of -7 but if you want only to subtract what is available (so in this case you would only want to subtract 5 instead of 12 because 5 is all that is left) that would require some other calculation. So, which would it be?
    Bob Larson
    Former Access MVP
    2008-2010

  2. #2
    Join Date
    Aug 2009
    Posts
    50
    Quote Originally Posted by boblarson View Post
    Do you just do not want negatives, or do you want it so you can't subtract more than is available?

    So, using the Abs function as Allan has said, would yield 7 instead of -7 but if you want only to subtract what is available (so in this case you would only want to subtract 5 instead of 12 because 5 is all that is left) that would require some other calculation. So, which would it be?
    Good Morning Bob

    your word underlined here bellow that is exactly i need provide me the calculation

    (so in this case you would only want to subtract 5 instead of 12 because 5 is all that is left) that would require some other calculation. So, which would it be?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •