Joined: 20 Oct 2006 Posts: 6962 Location: porcelain throne
well first of all, you have to realize that nnnnnnnnnnoooooooooo numeric type field has the decimal point.
it is implied.
if this were true: Mainframe Skills: Rexx/Cobol/Jcl/PL1/Eztrieve/DB2
you would have known that.
since your profile overstates your skills,
I will provide you an answer that actually belongs in the students' forum (as I think you do)
suggest you look for something called an 'edit mask'.
either that or you must redefine price value (needs to be W 9 A
into 3 fields
1st): Non-decimal-amount W 6 N 0
2nd): decimal-point W 1 A (value '.' or move a '.' to decimal-point)
3rd): decimal-amount w 2 N 2