Validating a number field

[Ronzues]

Sorry about this because I am sure that it is probably easy for all of you but I need to validate a field and I can't figure out the right way to make it work.

I need to validate it by a calculation that will only let the user input "10" or "20 or "30" or "40" and so on up to "100".

Can someone please help me out with this?

Ron

[-Queue-]

field > 0 and not Mod( field, 10 ) and field < 101.

[Riley Waugh]

If you only have the 10 possible values (10,20,30,etc.) then you might want to validate by value list and make a value list containing the ten values. You could then, as well, provide the user with a pop up list.

[Ronzues]

ok, let me verify what I am trying to do. Things have changed since my original post.

I have a field that I want the users to be able to enter a number between 1-100. This number will be a percent and will be part of a calculation.

Percent x Number = Product

I know how to do the calculation to achieve the Product field.

What I don't know is how I can allow them to enter a whole number 1-100 and then have that be converted to a decimal to muliply correctly without them having to convert it to a decimal and enter it as for ex. .20

[Ugo DI LUCA]

You would have to decide wether 15 is 10 or 20, but you'd get an answer here

HTH

[Riley Waugh]

if the number is the contents of a field named number, and your user enters a whole number in the percentage field, then the product field is a calculation field...

Product = Percent * Number * .01

Of course, a user might try to enter a percentage such as .56 in which case you must do something. One way would be to prevent the user from entering a percentage by validation... you could validate the percentage field in the options of the define field window... validate by a range of between 1 and 100.