Access - Changing format to %

  • I created an Access database. I have a percentage field in the table which statements the amount of discount the customer received on our company products.

    the problem is this

    If we want to give the customer a 30% discount we should be able to type in .3 and it should display 30%. Instead, it is displaying 0.00%.

    If you type in 30 it displays 300%.

    What do I have to do to correct this.

    Thank you in advance

  • Re: Access - Changing format to %

    I would imagine it's something simple like your field's data type setting.

    My guess is that it's set to the default number data type, Long Integer - change this setting (I think it's called Field Size in Access) to Double and you should be able to enter what you need and have it display correctly.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!