absolute value in access query

Discussion in 'Access Queries' started by Jacki, Sep 7, 2003.

  1. Jacki

    Jacki Guest

    How do I get a result that is an absoute value in a query?
     
    Jacki, Sep 7, 2003
    #1
    1. Advertisements

  2. You can use the abs function.

    So,

    select Customer, abs([Payments]) as churnRate from tblCustomers


    Simply put, abs returns a positive value for any given negative number...

    --
    Albert D. Kallal (MVP)
    Edmonton, Alberta Canada

    http://www.attcanada.net/~kallal.msn
     
    Albert D. Kallal, Sep 7, 2003
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. jw

    calculate absolute mean

    jw, Oct 20, 2003, in forum: Access Queries
    Replies:
    2
    Views:
    68
  2. MarkD

    Absolute value of a checkbox in a query

    MarkD, May 27, 2004, in forum: Access Queries
    Replies:
    4
    Views:
    73
    MarkD
    May 28, 2004
  3. gwiegel
    Replies:
    1
    Views:
    69
    KARL DEWEY
    Aug 12, 2005
  4. RobertM

    absolute value

    RobertM, Apr 19, 2006, in forum: Access Queries
    Replies:
    2
    Views:
    94
    John Spencer
    Apr 19, 2006
  5. Steve E
    Replies:
    1
    Views:
    93
    John Spencer
    May 25, 2006
  6. Terry
    Replies:
    3
    Views:
    65
    Marshall Barton
    Jul 24, 2008
  7. ComTech
    Replies:
    6
    Views:
    211
    ComTech
    Oct 15, 2008
  8. newby
    Replies:
    1
    Views:
    58
    Marshall Barton
    Nov 29, 2009
Loading...