Access keeps rounding down my numbers in a number field

[tsmith0125]

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!!!!!

 

[John W. Vinson]

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.