Hi there,
I've got a table that records translation quality assessments. It has 5 columns:
- ContractorID
- JobID
- SourceLanguage
- TargetLanguage
- Grade
I'd like to calculate the average grade for a specific contractor by language combination, ie if there are several jobs with the same language combination for one contractor, average the grade value.
I've tried in different ways, but being an Access newbie, I'm slightly stuck.
Any help would be greatly appreciated!
Thanks!
Sengad
I've got a table that records translation quality assessments. It has 5 columns:
- ContractorID
- JobID
- SourceLanguage
- TargetLanguage
- Grade
I'd like to calculate the average grade for a specific contractor by language combination, ie if there are several jobs with the same language combination for one contractor, average the grade value.
I've tried in different ways, but being an Access newbie, I'm slightly stuck.
Any help would be greatly appreciated!
Thanks!
Sengad