I have a Microsoft Access database where the user is required to enter the yield into a field, ranging from 0% to 100% for the record.
The field has been setup as 'percent' data type, but for some reason, it always rounds it to 100% and stores 100% in the table. Even if I do it as a 'general number', it will always round to 1.
Any thoughts as to why? This may be simple, but I'm stumped on this one.