 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / June 2007Displaying decimal places in Access
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 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  SignatureWayne Manchester, England. > 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 [quoted text clipped - 3 lines] > Hoping someone can help > 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. > How is the data rounded up and down ?? > [quoted text clipped - 8 lines] > > Hoping someone can help > > 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. 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. SignatureJoseph Meehan Dia 's Muire duit > 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 [quoted text clipped - 3 lines] > Hoping someone can help > jille What is the data type of the field in question? Is it Integer? SignatureJoseph Meehan Dia 's Muire duit |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.