Re: Compare currency to a double

On Tue, 12 Jul 2005 09:06:07 -0700, "DSTDIVA3"
<DSTDIVA3@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>That did work, but I have another question that deals with the same concept.
>I have an if statement that checks whether the values are not equal. At one
>point I have a value in one and null in the other, but it did not perform the
>procedure. I can't use isnull because sometimes there are values that are
>not equal and I need that value to update the spread***. What am I doing
>incorrectly?

I don't know, because you did not post your code, so I don't know what
you're doing.

One thing to consider is that NULL is not equal to anything, even to
NULL; nor is it unequal to anything. Any comparison to NULL returns...
NULL.

You can sometimes use NZ([fieldname], -1)

to replace NULL by some value which will never be used (-1 in my
example, you may need some other number); or a syntax

[FieldA] <> [FieldB] OR [FieldB] IS NULL


John W. Vinson[MVP]
.

Quantcast