Displaying decimal places in Access

J

jille

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
 
W

Wayne-I-M

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
 
J

jille

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.
 
Top