How do I display a decimal places as a percentage in Access?

[Guest]

I imported a file from Excel to Access containing percentages. I am trying
to display a field containing decimals as a percentage. Now I have the data
type set up as Number, but I do not know how to set up the field properties
so the percentage can display as, for example, 28.6 or 1.9. Must the data be
in a specific format in Excel in order to easily display as a percentage in
Access?

 

[John Nurick]

Hi Monica,

There are two things here:

First, the number field in Access must be one that can store decimals
and not just whole numbers. This means setting the field size to Double
or Single rather than the default Long.

Second, in both Access and Excel percentages are very often stored as
fractions (e.g. 28.6% stored as 0.286, 1.9% stored as 0.019). Applying a
"percent" format to the field or cell shifts the decimal point two
places and adds the % sign.

So if you have an Excel field containing percentages as described above,
import it into a Double field in Access (which is the default if you
import it to a new table) and if necessary apply a "percent" format to
the field and/or the controls that you use to display it.