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
|
|||
|
|||
Access keeps rounding down my numbers in a number field
I have created a database for a non-profit that must show at least 75%
participation. When an attendee meets 4 of 6 hour attendance the program rounds down to 4 from 4.5. I have tried all formats and only currency shows 4.5, but of course that is with a $. HELP!!!!! -- tsmith0125 |
#2
|
|||
|
|||
Access keeps rounding down my numbers in a number field
On Sat, 10 Oct 2009 17:11:01 -0700, tsmith0125
wrote: I have created a database for a non-profit that must show at least 75% participation. When an attendee meets 4 of 6 hour attendance the program rounds down to 4 from 4.5. I have tried all formats and only currency shows 4.5, but of course that is with a $. HELP!!!!! The format is almost surely irrelevant. I suspect that you're trying to store the participation or the attendance (it's not clear from your post where you're trying to store the 4.5) is a Number field of the default "Long Integer" size. Open the table in design view, select the field, and look at the field properties in the lower left. A Long Integer is by definition a whole number and will not store fractions. Change the size to Single to allow frational values to be stored. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|