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. Advertising

  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. Advertising

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. A-JA
    Replies:
    0
    Views:
    108
  2. jon west

    Absolute absolute cell reference

    jon west, Oct 9, 2003, in forum: Excel Misc
    Replies:
    2
    Views:
    126
    Peo Sjoblom
    Oct 9, 2003
  3. Fred
    Replies:
    3
    Views:
    122
    Juan Sanchez
    Jul 1, 2004
  4. Mike K
    Replies:
    1
    Views:
    124
    John C
    Oct 8, 2008
  5. John
    Replies:
    0
    Views:
    98
Loading...

Share This Page