formulas in Access

[Guest]

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!

 

[Mikal via AccessMonster.com]

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!

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

--
Mike Pippins

"We have met the enemy and he is us." -- Pogo Possum

Message posted via AccessMonster.com