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
|
|||
|
|||
Number Rounding
How do I prevent rounding up or down. I'm using 2000 and regardless of what
type number I select, the result is rounding up or down. I want to be able to enter a number i.e. 1.5 and have it appear and calculate as 1.5. Thanks! |
#2
|
|||
|
|||
Open your table in design view.
Select the problem Number field. In the lower pane of table design, set the Field Size to: Double The Integer types handle whole numbers only. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Sam" wrote in message news How do I prevent rounding up or down. I'm using 2000 and regardless of what type number I select, the result is rounding up or down. I want to be able to enter a number i.e. 1.5 and have it appear and calculate as 1.5. Thanks! |
#3
|
|||
|
|||
What is the "Field Size" for the column? If it is set to Long Integer (the
default for numbers) it will always round to the nearest whole number value. Change it to Single, Double, or Currency. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm "Sam" wrote in message news How do I prevent rounding up or down. I'm using 2000 and regardless of what type number I select, the result is rounding up or down. I want to be able to enter a number i.e. 1.5 and have it appear and calculate as 1.5. Thanks! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
incorrect sums in report using 2 tables | jkendrick75 | Setting Up & Running Reports | 22 | December 13th, 2004 02:19 PM |
Rounding Up to next whole number | Brad | New Users | 6 | December 5th, 2004 06:31 AM |
Rounding and why must I use general number data type? | Febra | General Discussion | 2 | September 24th, 2004 05:29 PM |
Rounding to a whole number | Randy | Setting Up & Running Reports | 2 | September 13th, 2004 10:20 PM |