Results 1 to 10 of 10
  1. #1
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,371
    Thanks
    78
    Thanked 12 Times in 11 Posts

    Validation error (2007)

    I keep getting a message that the validation rule is incorrect.

    It is a currency field that must be at least $700 and not more than $1,500. I attache3d the property box image.

    What the heck is wrong with that validation rule?

    Regards,
    Chuck Billow
    Attached Images Attached Images
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Validation error (2007)

    Try

    <=1500 AND >=700
    Jerry

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Validation error (2007)

    Try

    Between 700 And 1500

  4. #4
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,371
    Thanks
    78
    Thanked 12 Times in 11 Posts

    Re: Validation error (2007)

    Jerry, that worked.

    Why? I mean, I can see why, but why? Because the < amount was first?

    ??

    Thanks,
    Chuck
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

  5. #5
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Validation error (2007)

    Hi Chuck

    It is a question of logic <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    When doing numerical compares like you are doing, it is best to start at the larger number and then go to the smaller number. The other way is to do it like Hans suggests and use the BETWEEN and AND, it makes life a little easier
    Jerry

  6. #6
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,371
    Thanks
    78
    Thanked 12 Times in 11 Posts

    Re: Validation error (2007)

    Well I certainly learned this time. Fell kind of "Duh!" but I'll probably survive!

    Thanks guys.

    Regards,
    Chuck
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

  7. #7
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Validation error (2007)

    Just out of interest, I recreated your original rule, and it worked fine for me.

    I would choose to use the Between syntax, but I can't see any reason yours should not work.


    What exactly was the error message, and when did it occur?
    Regards
    John



  8. #8
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,371
    Thanks
    78
    Thanked 12 Times in 11 Posts

    Re: Validation error (2007)

    John, I never got far enough to see if it worked, because when I went to save Validation, I would get an error.

    So I dunno.

    All I know is that Jerry's and Hans's both did.

    Maybe I'm jinxed!

    Regards,
    Chuck
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

  9. #9
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Validation error (2007)

    But what was the error?

    Was it this? I get this error if I put a space between the = sign and either of the others.
    Attached Images Attached Images
    Regards
    John



  10. #10
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,371
    Thanks
    78
    Thanked 12 Times in 11 Posts

    Re: Validation error (2007)

    John:

    I just went back and put the same formula in that I had used originally (that I showed in my original post) and received no error!

    Maybe I'm just going daft!

    Regards,
    Chuck
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

Posting Permissions

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