Can I use DLookup to do this?

[beaj]

I have two tables. One contains student details - name and grades (A+ to UG) for three different assessment tasks. The other table contains the grades and numerical scores for each grade.E.g A+ - 90, A - 80 and so on. I am trying to create a field which will show the average (in numberical value) for the three different assessment tasks. I can do it using nested ifs but it is messy. If it was done in a spreadsheet I could use VLOOKUP. Is there anything equivalent in Access.

 

[Lehtoant]

Hi Beaj,<br>
<br>
What your student table looks like? Is it like:<br>
StudentName ¦Task1 ¦Task2 ¦Task3<br>
Beaj ¦A+ ¦A- ¦A+ <br>
or <br>
StudentName ¦Task ¦ Grade<br>
Beaj ¦1 ¦A+<br>
Beaj ¦2 ¦A-<br>
Beaj ¦3 ¦A+<br>
<br>
In Access there's a function DAvg, which will do this calculation easily, if your table is organised as the latter style.<br>
<br>
Al<br>