The percent field in my Access 2000 changes all decimals to 0%

J

jlpirozzi

In my database, I have a field for % complete. It is defined in a table as a
%, but it will not convert a decimal to the correct percent. 1 changes to
100%, 10 to 1000%, but .10, .20, .25 etc changes to 0%
 
W

Wayne Morgan

What is the Field Size of the field in the table. If it is an Integer or
Long, it is probably being converted to zero since those data types can't
have a decimal.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Percent Format 10% shows 1000% 10
Format a Percent 4
Formatting a percent field 1
Format a percent field 1
Format a percent 7
Format in Text Field Changes 6
Percent problems 4

Top