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
|
|||
|
|||
Numeric field is rounding up
I have a numeri field that is set for two decimal places.
However, when I enter a number 6.80, it rounds up to 7.00. Does anyone have any ideas / suggestions? Brook |
#2
|
|||
|
|||
Numeric field is rounding up
Make sure that the numeric type is single, double, or currency depending on how large a number you need to hold. It sounds like you have it set to the default which is long integer. An integer is a whole number.
-- Bridge Players know all the Tricks "Brook" wrote: I have a numeri field that is set for two decimal places. However, when I enter a number 6.80, it rounds up to 7.00. Does anyone have any ideas / suggestions? Brook |
#3
|
|||
|
|||
OT: Pat Hartman's sig
On Wed, 28 Jul 2004 17:36:09 -0700, "Pat hartman"
wrote: Bridge Players know all the Tricks .... and the only thing worse than three bridge players who don't have a fourth, is four bridge players who do have a fifth! g Welcome to the newsgroups, Pat. Good answers... just don't trump your partner's ace! John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Blank Numeric Field | Mark S | Using Forms | 1 | July 14th, 2004 08:16 AM |
NUMBERING the pages | Bob | New Users | 7 | June 14th, 2004 12:20 AM |
How to Join Chacter Field to Numeric Field | Racer57 | Running & Setting Up Queries | 6 | June 7th, 2004 09:23 PM |
Please help! Displaying only rows with empty cells in a numeric field using Advanced Filter. Thanks | JOCA | New Users | 1 | June 5th, 2004 02:37 AM |