Hi - I am trying to have a field be a Percent Format.
In access 2007, I am reading that I should just have the properties be:
Number
- Field Size: Long Integer
- Format: Percent
- Decimal Places: 2
However, in the table, when I enter a number that is smaller than 100 now, it automatically shows ZERO. When I enter 100, it shows it as 100% (and the same for any number above 100).
Then, I tried to just change the format to General Number, with 2 decimal places.
When I try to enter say, 0.45 - it changes it to zero. It does not show the two decimals. When I enter in 0.9, it rounds it up to 1
Please advise.
Thanks!