Hi,
I'm working in a school and I need to run a report where I can pull out all students who scored all "A's" for their grades, all "1's" for their effort and who scored both and "A" and a "1" in all subjects they took.
The basic data sheet looks like this:
<tbody>
</tbody>
So the results expected should be:
All "A's" - Ben Smith, Simon West
All "1's" - Ben Smith, Jill Brown
All "A's and 1's" - Ben Smith
Any advice would be appreciated.
Thanks.
I'm working in a school and I need to run a report where I can pull out all students who scored all "A's" for their grades, all "1's" for their effort and who scored both and "A" and a "1" in all subjects they took.
The basic data sheet looks like this:
StudentCode | Name | Subject Code | Subject | Grade | Effort |
1000 | Ben Smith | 10PHYS | Year 10 Physics | A+ | 1 |
1000 | Ben Smith | 10PE | Year 10 PE | A | 1 |
1000 | Ben Smith | 10MATH | Year 10 Math | A- | 1 |
1001 | Jill Brown | 10PHYS | Year 10 Physics | B+ | 1 |
1001 | Jill Brown | 10DRAMA | Year 10 Drama | A | 1 |
1002 | Simon West | 10PE | Year 10 Phys Ed | A+ | 2 |
1002 | Simon West | 10MUSIC | Year 10 Music | A- | 2 |
1002 | Simon West | 10ENG | Year 10 English | A | 1 |
1002 | Simon West | 10MATH | Year 10 Math | A- | 1 |
1003 | Sarah White | 10PE | Year 10 Phys Ed | B- | 2 |
1003 | Sarah White | 10DRAMA | Year 10 Drama | C | 3 |
<tbody>
</tbody>
So the results expected should be:
All "A's" - Ben Smith, Simon West
All "1's" - Ben Smith, Jill Brown
All "A's and 1's" - Ben Smith
Any advice would be appreciated.
Thanks.