How can I change a number score to a letter grade in Access?

J

jerrodklein313

I am building a record database for my childrens grades. I want to creat a
report card. I am having troble converting a percentage to a letter grade.
For example, my daughter recieved an overall 91% in spelling class. I would
like it to reflect an as the letter grade "A." I will then create a report
card. Any help witrh this matter will be greatly appreciated. Thank you.
 
M

M.L. Sco Scofield

I've got a sample that does this.

It's in all of the join presentations that I've done.

Download either the May 2003 or May 2004 file from the "Presentations" page
on my site. (URL below.)

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
M

M.L. Sco Scofield

They just can't get enough of me! :)

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
Top