I really want a way to find students grades based on their marks

Numbero Uno - My Question

OK I will tell you my problem before I tell you how I have tried to solve it.

I would like to have, in my form, a field that is able to tell me what grade a student got based on their final marks. The grade would be 70+ A, 60+ B, 50+C etc. How would one do this in access?



Part Deux - Where I tried to figure it out on my own but failed.


This is my lovely efficient forumla from excel:

=IF(L7>69.49,"A",IF(L7>59.49,"B", IF(L7>49.49,"C",IF(L7>39.49,"D","F"))))

As you can see it finds out whether a student received an A, B, etc. Simples!

However so far all I have discovered in Acces is to input this into the Control Source:

=IIf([Module One Final Mark]>69.49,"A","F")

I tried inputting the same kind of categories into the control source but it was given answers as -1. The AND button is also obviously pointless, from what I can tell it works fine on Queries but the AND button seems to do the same here as in Excel so.. I do not except it to be useful to me.

Any suggestions? I would rather keep out of VBA but I am starting to think I will have to start teaching myself how to do that as well to sort this out.

ANY HELP WILL BE MUCH APPRECIATED

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.