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