Thanks for the reply.
I am trying to avoid storing the field pGrade as it is a calculated field which will, in this case, only be used for 'what if' reporting'. My thought had been to have some SQL statement as RecordSource to a report --
SELECT GradeName, Handicap, Grade from tPlayers LEFT...