Displaying decimal places in Access

[Guest]

Can I pursuade Access to show me decimal places on data I have already
entered. At the moment everything gets rounded up or down. I've done what
is needed to change for future inputing but old data is still not showing
what I want.

Hoping someone can help
jille

 

[Guest]

How is the data rounded up and down ??

Can you give a detailed sample includeing field names or control names and
any formulas that are used

 

[Joseph Meehan]

Can I pursuade Access to show me decimal places on data I have already
entered. At the moment everything gets rounded up or down. I've
done what is needed to change for future inputing but old data is
still not showing what I want.

Hoping someone can help
jille

What is the data type of the field in question? Is it Integer?

 

[Guest]

Data relates to metric measurements, height, weight etc. Field properties
were set to Longinteger at first. Have now set them to Double, fixed format
and 1 or 2 decimal places. This means it now displays what I want for all
new data but old data still appears rounded up eg 26.0. The form I created
to input data is bound to a table; data displays in same format in both.
Original data was input as if it were a decimal. I know Access stores
original input for calculations. Can I pursuade it to show me? Using Access
2003 on windows XP.

 

[Joseph Meehan]

Data relates to metric measurements, height, weight etc. Field
properties were set to Longinteger at first. Have now set them to
Double, fixed format and 1 or 2 decimal places. This means it now
displays what I want for all new data but old data still appears
rounded up eg 26.0.

That old data was not just rounded to 26.0 it was changed to 26.0
Integers (long or short) are .. well integers.

in·te·ger (¹n"t¹-j.r) n. Mathematics. 1. A member of the set of positive
whole numbers (1, 2, 3, . . . ), negative whole numbers (-1, -2, -3, . .
.. ), and zero (0). 2. A complete unit or entity.

Integers are only whole numbers. They don't have decimals.

Now that you have changed the filed, you can go back and adjust them.
Sorry, but Access did not store the lost data. If you still have the data
that was lost in a computer readable format, you may be able to replace the
existing data with the original data.