I think it's conditional?
My database has students who are awarded - Pass, Merit or Distinction for each unit they complete. These three grades need numerical values attached. Pass = 2 Merit = 4 Distinction = 6 in order to work out there final grade points. How can I add these values up in a new field to show totals of each unit completed?