Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2010

    Unanswered: ACCESS '07 QUERY - filter out $0.00

    Thanks for reading my post!

    Does anyone have a trick for filtering out 0.00 balances in a query calculation?

    I am subtracting payments from invoice amount and use number datatypes in my table.
    (I need this because the both fields are used in various calculations throughout the database and some won't work with currency.)

    I can change the format in the query to standard number or currency and get 0.00 or $0.00 respectively, but since the underlying calculation is out to the 15th digit - my >0 filter has no effect

    Here is an example of a calculation -
    inv amt = 5757.96
    PD = 5757.96
    bal = 3.90625000363798E-05

    so in reality this invoice is paid in full and I need it filtered out.

    How can I work around this?

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    so format the balance using say,format(myvalue,"#,##0.00")
    the 3.90625000363798E-05 is an artifcat of using double precision values
    use a more appropriate datatype for the values (probably currency)
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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