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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement