Hi there,
I'm new to Access and know pretty much nothing about coding.
I have a table ("Student Info") that looks like this:
ID....Student.....Student #......Teacher Name......Teacher ID
1........A...............432...............Alice...................62
2........B...............674...............Alice...................62
3........C...............875...............Alice...................62
4........D...............934...............Katie..................18
5........E...............345...............Katie..................18
6........F...............134...............Dan.....................4
7........G...............734...............Dan.....................4
The above table suits me well for data entry.
For analysis reasons, I want it to have another table or query or something (let's call it "Teacher Info") that looks like this:
Teacher ID....Teacher Name....St1.....St2......St3...St#1...St#2...St#3
62......................Alice...........A.........B........C.....432.....674.....875
18......................Katie...........D.........E........-.....934.....345......-
4........................Dan............F.........G........-.....134.....734......-
Is there any way that I could do this? I have been struggling with this for a while.
Just so you know how this data is connected - At the moment, I have a form where I put in new Teacher information. I have a subform attached to that, where I put the student names and numbers. This way, the students are linked with their student #s, and each of them are linked to a teacher. Unfortunately, the table ("New Teacher Registration") that this creates looks like this:
id....Teacher Name
62...... Alice
(+ tab).........A.........432
...................B.........674
...................C.........875
18.......Katie
(+ tab).........D.........934
...................E.........345
4........Dan
(+ tab).........F.........134
...................G.........734
I created the "Student Info" table (above) from this to help with data entry (drop-downs and such). Now I'd like to create a "Teacher Info" table (above) for analysis help.
If someone could please help me with this, I would be very, very grateful!
Thanks!
Sarah
I'm new to Access and know pretty much nothing about coding.
I have a table ("Student Info") that looks like this:
ID....Student.....Student #......Teacher Name......Teacher ID
1........A...............432...............Alice...................62
2........B...............674...............Alice...................62
3........C...............875...............Alice...................62
4........D...............934...............Katie..................18
5........E...............345...............Katie..................18
6........F...............134...............Dan.....................4
7........G...............734...............Dan.....................4
The above table suits me well for data entry.
For analysis reasons, I want it to have another table or query or something (let's call it "Teacher Info") that looks like this:
Teacher ID....Teacher Name....St1.....St2......St3...St#1...St#2...St#3
62......................Alice...........A.........B........C.....432.....674.....875
18......................Katie...........D.........E........-.....934.....345......-
4........................Dan............F.........G........-.....134.....734......-
Is there any way that I could do this? I have been struggling with this for a while.
Just so you know how this data is connected - At the moment, I have a form where I put in new Teacher information. I have a subform attached to that, where I put the student names and numbers. This way, the students are linked with their student #s, and each of them are linked to a teacher. Unfortunately, the table ("New Teacher Registration") that this creates looks like this:
id....Teacher Name
62...... Alice
(+ tab).........A.........432
...................B.........674
...................C.........875
18.......Katie
(+ tab).........D.........934
...................E.........345
4........Dan
(+ tab).........F.........134
...................G.........734
I created the "Student Info" table (above) from this to help with data entry (drop-downs and such). Now I'd like to create a "Teacher Info" table (above) for analysis help.
If someone could please help me with this, I would be very, very grateful!
Thanks!
Sarah