Hi!

I have a table called called ORDERS DETAIL and a field called DISCOUNT located inside that table. I want the field to only hold numbers b/w 0 and 1, and I would also like to have a percent sign appear each time a number is entered.

So, in my field level validation box, I placed the expression:

BETWEEN(ndiscount,0,1)

That expression works just fine.

However, I would like to use whole numbers with a percent sign instead. Currently, if I input 14, it would look like this:

0.14

But, I want it to look like 14%

1. What do I need to type into the format box in the table designer to achieve this goal? Is my problem with the expression I have in my field level validation box? Should I be using the integer data type field instead of the numeric data type field set to 2 decimal places?

Thank you in advance for any help.

Jason