Results 1 to 2 of 2
  1. #1
    ChristopherL is offline Novice
    Windows XP Access 2002
    Join Date
    Jul 2013
    Posts
    18

    Abs function!

    Hiho!


    Quick and probably easy question..
    When I use the Abs([FieldName])
    Is there a way that I can show the abs value both negative and positive?
    Right now if the Abs value is negative it sets it to positive on its own!

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    Can you tell us what the context is? Give an example of WHAT you want.

    You could try MyString = "+/- " & Abs(YourVariable)
    Abs will give you the numeric value o the variable/expression regardless of sign.
    http://www.techonthenet.com/access/functions/numeric/abs.php



Please reply to this thread with any new information or opinions.

Similar Threads

  1. IIf Function, please help
    By Georgi in forum Forms
    Replies: 3
    Last Post: 01-05-2013, 07:28 PM
  2. VBA Function
    By antoncata in forum Programming
    Replies: 16
    Last Post: 02-11-2012, 07:50 PM
  3. Bug in RND() function?
    By Robeen in forum Access
    Replies: 2
    Last Post: 12-21-2011, 09:07 AM
  4. if function
    By lolo in forum Queries
    Replies: 1
    Last Post: 08-01-2010, 11:38 PM
  5. Want function to get current function name
    By Davis DeBard in forum Programming
    Replies: 2
    Last Post: 08-13-2009, 05:02 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums