Search results

I have a table with student marks in, and I want to allocate a grade which corresponds to the score, eg over 6 is an A, over 5 is a B etc. Vlookup or nested if do it beautifully on Excel. Any idea how I can do it on Access other than using a VBA If else statement which seems a bit complex? Iif...