Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2012
    Posts
    21

    Question Unanswered: Exclude Zero Values in Query

    To simplify my scenario, I have an Access Database process that imports data. It then subtracts Field-1 from Field-2 and returns the results in Field-3.
    I would like to view all positive and negative results and exclude all $0.00 values in my Query. For some reason, I still get $0.00 return values when using the expression <> 0.

    I've tried various reformatting combinations for Field-1, Field-2 and Field-3 in my Table (i.e. [Integer, Double, Single], [Standard, Currency], [two decimal places]).

    I would greatly appreciate any assistance with this problem.

    Thx -Tim

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Test for NOT BETWEEN -0.005 AND 0.005 instead of <> 0 and I would expect better luck.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Sep 2012
    Posts
    21
    Outstanding, Pat! That fixed my problem that I've worked tireless hours on. I'm very grateful for forums like these and people like you who are willing to take the time to share their knowledge. Thx a bunch! -Tim

Posting Permissions

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