1. ## 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

2. ## Re: Validation error (2007)

Try

<=1500 AND >=700

3. ## Re: Validation error (2007)

Try

Between 700 And 1500

4. ## Re: Validation error (2007)

Jerry, that worked.

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

??

Thanks,
Chuck

5. ## 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

6. ## Re: Validation error (2007)

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

Thanks guys.

Regards,
Chuck

7. ## 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?

8. ## 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

9. ## 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.

10. ## 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

#### Posting Permissions

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