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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. jw

    calculate absolute mean

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

    Absolute value of a checkbox in a query

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

    absolute value

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