Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    41

    Unhappy Unanswered: Equation not working

    I am using the following statement to verify that dimensions are in ascending order (L, W, H)

    "Dim In Order": IIf(([l]>[w] Or [l]=[w]) And ([w]>[h] Or [w]=[h]),"True","False")

    It works fine if the dimensions are not equal, but the following record returns "False" when it should return "True":
    L=8
    W=7
    H=7

  2. #2
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    Select IIf(([l]>[w] Or [l]=[w]) And ([w]>[h] Or [w]=[h]),"True","False")
    from a

    where l = 8, w = 7 and h=7 returned True.
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  3. #3
    Join Date
    Mar 2004
    Posts
    41
    Ahem...

    If you widen the column, the actual number appears. In this case, 8 x 6.5 x 6.875.

    Thanks, |r12346|

Posting Permissions

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