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

On Sat, 10 Oct 2009 17:11:01 -0700, tsmith0125
<(E-Mail Removed)> 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]