D
Deac
Non-profit work for a dance school.
One Query based on three tables but used twice.
I need to automate it more than it is.
I can put in a class name and get a list of the students in that
class. (Good)
(I can do a MakeTable to have just the Name and ID for each of them.)
I can change it to put in each student ID and I get a list of each
students' classes (Good)
What I get is:
Class ID Name ClassAll
class1 1248 John Doe Jazz
class1 1469 Mary Phillips Jazz
class1 1469 Mary Phillips Modern
class1 1553 Terri Johns Jazz
class1 1553 Terri Johns Hip-Hop
class1 1553 Terri Johns Modern
What I need on the Report is:
ID Name Class1 Class2 Class3
Class4
1248 John Doe Jazz
1469 Mary Phillips Jazz Modern
1553 Terri Johns Jazz Hip-Hop Modern
This is getting over my head but my questions are:
Do I need the MakeTable?
Should this be done with a Crosstab, to get this layout, or is there a
better way?
Any and all help is appreciated!
One Query based on three tables but used twice.
I need to automate it more than it is.
I can put in a class name and get a list of the students in that
class. (Good)
(I can do a MakeTable to have just the Name and ID for each of them.)
I can change it to put in each student ID and I get a list of each
students' classes (Good)
What I get is:
Class ID Name ClassAll
class1 1248 John Doe Jazz
class1 1469 Mary Phillips Jazz
class1 1469 Mary Phillips Modern
class1 1553 Terri Johns Jazz
class1 1553 Terri Johns Hip-Hop
class1 1553 Terri Johns Modern
What I need on the Report is:
ID Name Class1 Class2 Class3
Class4
1248 John Doe Jazz
1469 Mary Phillips Jazz Modern
1553 Terri Johns Jazz Hip-Hop Modern
This is getting over my head but my questions are:
Do I need the MakeTable?
Should this be done with a Crosstab, to get this layout, or is there a
better way?
Any and all help is appreciated!