Number Format and percent

[Guest]

Dear all,
1. I am new to access program. I need to have 0.67 in a column in a table
but when I put this into the column then it returns me 1. Is there a way to
have it 0.67?
2. I need to have percent format in one of my columns, but instead of 5% it
shows 500%, I want to have it as 5%.

I will be thankful to receive feedbacks on the above issues.

Thanks, Daoud

 

[Guest]

1. If your field is long integer it won't work. I use decimal

2. Don't multiply by 100 (the percent format does it for you)