• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 271
  • Last Modified:

If then to Exclude If Currency Value =$0.00

I am trying to not include, If the currency field is null or has a value of $0.00.  I tried many variations on the line below. If the field is null, the code skips, as it should, but when the value in the field is $0.00 the code runs.  Please help..

   If Not IsNull(CurrencyField) Or CurrencyField.Value <> 0# Then
1 Solution
If Nz(CurrencyField) <> 0 Then
ml-sdAuthor Commented:
Thank you so much for the quick answer...
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now