pickslides
Red Sails In The Sunset
- Local time
- Today, 13:03
- Joined
- Apr 29, 2008
- Messages
- 76
Hi all,
Please see DB attached.
I wish to count how many students are in each subject by year level
Output for this table would be a crosstab (select query is fine)
Subject / Year Level .... 7 ..... 8
Math ...... 8 ....... 5
Sport ...... 5 ......... 3
Thanks, Q
Please see DB attached.
I wish to count how many students are in each subject by year level
Output for this table would be a crosstab (select query is fine)
Subject / Year Level .... 7 ..... 8
Math ...... 8 ....... 5
Sport ...... 5 ......... 3
Thanks, Q