Ok, I'm on my way. My data is normalized and just as i thought things are going good, things got bad again. I'm busy creating a form to enter data. Most of my fiels have type number(double) and set to percentage.
My problem is: the person capturing the data won't divide each value by 100 to get a decimal value (which access converts back to %). How do I accept the value being entered ie when 4.5 is entered it reads it as 4.5% and not 450%.
Alternatively, I must build an event procedure to divide the value entered by 100. I'll need help with this.
My problem is: the person capturing the data won't divide each value by 100 to get a decimal value (which access converts back to %). How do I accept the value being entered ie when 4.5 is entered it reads it as 4.5% and not 450%.
Alternatively, I must build an event procedure to divide the value entered by 100. I'll need help with this.
