I have a problem with creating a query summarising some crosstab data. I have a database designed to record employee performance for each activity they perform. I have created a network of queries and OWC graphs to present summaries of this raw data, which is linked to a form which filters the data. This all works fine but I am having difficulty in creating a query which shows the combined overall score for every activity ever by every employee.
I already have an overall score for each individual activity type for each employee, represented in a crosstab as such (in itself significantly wrangled from raw data for every single time the activity was performed and weightings subsequently applied to each one):
Activity | Employee1 | Employee2 | Employee3
ActivityType1 | 3.2 | 2.5 | 4
ActivityType2 | 2.7 | | 2.2
ActivityType3 | 3.7 | 1.7 | 2.5
What I need to make is either this:
Activity | Employee1 | Employee2 | Employee3
AverageOfAllActivities | 3.2 | 2.1 | 2.9
Or this:
Employee | AverageOfAllActivities
Employee1 | 3.2
Employee2 | 2.1
Employee3 | 2.9
with which to generate related queries and bar graphs. The scores come from a value field WeightedScore
The issue that I've been having is that I'm not wanting a row heading to group by for the activity in this summary, yet Access insists that I group by both a row and a column heading. I just want to take the average of WeightedScore and depict it alongside the employee, regardless of the ActivityType that it came from.
I have the distinct feeling that I'm missing an obvious solution but it hasn't come to me.
Thanks in advance!
I already have an overall score for each individual activity type for each employee, represented in a crosstab as such (in itself significantly wrangled from raw data for every single time the activity was performed and weightings subsequently applied to each one):
Activity | Employee1 | Employee2 | Employee3
ActivityType1 | 3.2 | 2.5 | 4
ActivityType2 | 2.7 | | 2.2
ActivityType3 | 3.7 | 1.7 | 2.5
What I need to make is either this:
Activity | Employee1 | Employee2 | Employee3
AverageOfAllActivities | 3.2 | 2.1 | 2.9
Or this:
Employee | AverageOfAllActivities
Employee1 | 3.2
Employee2 | 2.1
Employee3 | 2.9
with which to generate related queries and bar graphs. The scores come from a value field WeightedScore
The issue that I've been having is that I'm not wanting a row heading to group by for the activity in this summary, yet Access insists that I group by both a row and a column heading. I just want to take the average of WeightedScore and depict it alongside the employee, regardless of the ActivityType that it came from.
I have the distinct feeling that I'm missing an obvious solution but it hasn't come to me.
Thanks in advance!
