Hi all!
Before I went on holiday, I played around and managed to produce a cross-tab query which counted up the number of learners who passed a course, and broke this down by Special Educational Needs (e.g. Number of students with dyslexia who got 1 pass, 2 passes, 3 passes, etc). For some daft reason, I didn't save this on the test-run data and, you guessed it, got back from Cornwall and couldn't work out how I did it first time round! I now need to do this analysis for ethnic groups. If anyone can help refresh my memory, it would be gratefully appreciated!
So, here we go...
For the sake of simplicity, let's say we have 3 tables:
Young People demographic data (YP)
(YP).[yp ID]
(YP).[Name]
(YP).[DOB]
(YP).[Special Educational Needs]
(YP).[Ethnicity]
Courses (C)
(C).[course ID]
(C).[course name]
Enrolments (E)
(E).[enrolment ID]
(E).[yp ID]
(E).[course ID]
(E).[start date]
(E).[end date]
(E).[outcome] (this includes the option 'passed')
Now, from here I've created a query called 'Achievements' which includes:
(E).[enrolment ID]
(E).[yp ID]
(YP).[Name]
(YP).[Special Educational Needs]
(YP).[Ethnicity]
(E).[course ID]
(C).[course name]
(E).[outcome] - criteria set as 'passed'
From here, I want to have a cross-tab that has the column heading: e.g. 1, 2, 5, 6, 7, 10, 12, 23, (Number of passes) and row heading: White British, Black African, etc (the groups specified within [Ethnicity]). The table should be able to tell me how many White British learners got 2 passes, 4 passes, etc, compared with the other ethnic groups.
I KNOW this is possible because I managed to make Access do this with dummy data before I went on holiday. But I can't for the life of me remember how I did it!!! I've not had much luck searching around the internet.
Any help would be wonderful.
Thanks in anticipation
Steve
Before I went on holiday, I played around and managed to produce a cross-tab query which counted up the number of learners who passed a course, and broke this down by Special Educational Needs (e.g. Number of students with dyslexia who got 1 pass, 2 passes, 3 passes, etc). For some daft reason, I didn't save this on the test-run data and, you guessed it, got back from Cornwall and couldn't work out how I did it first time round! I now need to do this analysis for ethnic groups. If anyone can help refresh my memory, it would be gratefully appreciated!
So, here we go...
For the sake of simplicity, let's say we have 3 tables:
Young People demographic data (YP)
(YP).[yp ID]
(YP).[Name]
(YP).[DOB]
(YP).[Special Educational Needs]
(YP).[Ethnicity]
Courses (C)
(C).[course ID]
(C).[course name]
Enrolments (E)
(E).[enrolment ID]
(E).[yp ID]
(E).[course ID]
(E).[start date]
(E).[end date]
(E).[outcome] (this includes the option 'passed')
Now, from here I've created a query called 'Achievements' which includes:
(E).[enrolment ID]
(E).[yp ID]
(YP).[Name]
(YP).[Special Educational Needs]
(YP).[Ethnicity]
(E).[course ID]
(C).[course name]
(E).[outcome] - criteria set as 'passed'
From here, I want to have a cross-tab that has the column heading: e.g. 1, 2, 5, 6, 7, 10, 12, 23, (Number of passes) and row heading: White British, Black African, etc (the groups specified within [Ethnicity]). The table should be able to tell me how many White British learners got 2 passes, 4 passes, etc, compared with the other ethnic groups.
I KNOW this is possible because I managed to make Access do this with dummy data before I went on holiday. But I can't for the life of me remember how I did it!!! I've not had much luck searching around the internet.
Any help would be wonderful.
Thanks in anticipation
Steve