Can you have 'Multiple Validations' in one Field

[euphonium01]

I have a field in my Customers Table that is a Number type (to record the percentage level of interest). In the Validation property I have <=1 And >=0 to shows percentage. However, I would also like the entries into this field to be limited to increments of 10, such as : 0%, 10%, 20% etc; to 100%. Can anyone help with the correct Validation Rule to only allow increments of 10, and also the Validation Rule (<=1 And >=0) required to show percentages?

Many thanks
euphonium01

[June7]

Options:

1. combobox

2. rule: 0 Or 0.10 Or 0.20 Or 0.30 Or 0.40 Or 0.50 Or 0.60 Or 0.70 Or 0.80 Or 0.90 Or 1 Or Is Null

[Dal Jeanis]

Not sure why the validation rule to show percentages would **require** <= 100%. You could have 200% of something...

[euphonium01]

Not sure why the validation rule to show percentages would **require** <= 100%. You could have 200% of something...

The field using the percentage is called 'Sales Potential', the maximum chance of any sale could only be 100%, hence the <=100%? Unless there's another method I could use that will include something to restrict entries to 10% increments?

[Dal Jeanis]

June7's methods are easy. If it wasn't just 10% increments between 0% and 100%, then you could put a more complex validation test in VBA behind the "before update" event. But that's overkill here.

[euphonium01]

June7's methods are easy. If it wasn't just 10% increments between 0% and 100%, then you could put a more complex validation test in VBA behind the "before update" event. But that's overkill here.

I agree, having spoken to a few colleagues, a more complex validation would be required and would be overkill. I took June7's advice and created a combo box and set the 'Limit to List' property to Yes, solved the problem.

Thanks to you all for your input, the expertise I receive from people on this site is amazing!

euphonium01

[Dal Jeanis]

You're Welcome. If you haven't already, you can click the little sherriff's star under june7's best post to give her some love.
|
|
|
V