Average query (1 Viewer)

sengad

New member
Local time
Today, 23:20
Joined
Jan 17, 2014
Messages
1
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
 

Galaxiom

Super Moderator
Staff member
Local time
Today, 21:20
Joined
Jan 20, 2009
Messages
12,849
Turn on Totals in the query designer. (Right click on the grid)

Include ContractorID, SourceLanguage, TargetLanguge and Grade fields.

Change the Totals dropdown on Grade to Average.
 

Users who are viewing this thread

Top Bottom