Re: Compare currency to a double

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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 spreadsheet. 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]
.

Relevant Pages

  • Re: Compare currency to a double
    ... "John Vinson" wrote: ... >>not equal and I need that value to update the spreadsheet. ... you may need some other number); or a syntax ... Prev by Date: ...
    (microsoft.public.access.formscoding)
  • RE: GPA formula
    ... What type of grade format are you ... using in the spreadsheet? ... The in-line help will explain the syntax for the statement as you type it. ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: expression evaluation optimization
    ... > because I don't expect the "Is Null" syntax to work in VBA. ... If Not (myobj Is Nothing) And Not IsNullThen ... the case where myobj is something but its .property IsNull(). ... Prev by Date: ...
    (microsoft.public.access.modulesdaovba)
  • Re: transfer spreadsheet with spaces in the sheetname
    ... using this syntax when there are no special ... qualified as special characters, but since you are having problems, I ... worksheet has what *appears* to be a space, ... Are you sure the spreadsheet type is 8? ...
    (microsoft.public.access.modulesdaovba)
  • Re: Query based on Column Index
    ... If you were limited to using a spreadsheet, ... the only way to handle a changing situation. ... I have to manually determine Curr ... Prev fields from my table and update the query. ...
    (microsoft.public.access.queries)