|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 9th, 2005, 05:32 AM
|
|||
|
|||
Rounded up values
help, how to stop access from rounding up values you enter in a table?
i enter this 458.59 and access changes it to 459.00. I have the format set to standard and the decimal places set to auto and i have tried setting it to 2 but the same thin happens. HELP pls! 
|
|
#2
May 9th, 2005, 05:56 AM
|
|||
|
|||
|
"Mr. Capuchino" wrote in message news  help, how to stop access from rounding up values you enter in a table? i enter this 458.59 and access changes it to 459.00. I have the format set to standard and the decimal places set to auto and i have tried setting it to 2 but the same thin happens. HELP pls! What is the data type of the field?
|
|
#3
May 9th, 2005, 01:08 PM
|
|||
|
|||
|
Change your field type from Number- integer to Number-double
Ed Warren "Mr. Capuchino" wrote in message news help, how to stop access from rounding up values you enter in a table? i enter this 458.59 and access changes it to 459.00. I have the format set to standard and the decimal places set to auto and i have tried setting it to 2 but the same thin happens. HELP pls!
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Second serie doesn't use X-as values | JackRnl | Charts and Charting | 1 | January 20th, 2005 01:04 AM |
| Zero values in a log chart | Joelle_Smith | Charts and Charting | 1 | December 23rd, 2004 07:58 PM |
| average, eliminating zero values | Chris | Worksheet Functions | 6 | May 14th, 2004 11:36 PM |
| Look up values in one column based on values in another without repeating | fbarbie | Worksheet Functions | 0 | April 8th, 2004 09:38 PM |
| Conditional sum based on values in one or more columns | Mario | Worksheet Functions | 13 | December 23rd, 2003 09:38 PM |
Linear Mode
