formulas in Access

C

Cookie U

I have a formula set up to calculate GPA for students. When I put points in
the field, it changes up to the next whole number. For example, 1.2 will
become 2. How can I set this field to leave the number exactly as typed?
Thanks!
 
M

Mikal via AccessMonster.com

Cookie said:
I have a formula set up to calculate GPA for students.
How can I set this field to leave the number exactly as typed?
Thanks!
Click to expand...


Sounds like you have the fieldsize set to Integer or Long Integer. Try
setting it to Single or Double instead and make sure you allow more than 0
decimal places in both the table and in the controls on the forms used to
enter and display your data.
HTH
Mike
 
Top