Greetings:
I am new to Access VBA & am searching for a push in the right direction. I have a group of 147 high school teachers. I want to create a report (which I've done) & populate it only with students who appear on a Graduating Seniors TABLE. Each teacher teaches 5 of 9 periods throughout day.
How do I loop code for each period to pull only students for each teacher? (if that makes sense? sorry). I need to give them a list of their seniors in their classes but not all teachers teach each period. For example Ms. Andres has some students period 1 (TEACHER1) & period 6 (TEACHER 6).
Not sure how to start set up & if my thinking is correct...
Thanks in advance & let me know if I need to provide other info. I took a basic VBA course last summer & remember how to create a loop filter.
John
NY, USA
My table looks like this:
Student ID Student Name Official Class Attendance: YTD Credits Earned: Total Max Score: English Max Score: Global Max Score: US Max Score: Algebra Att: Algebra Max Score: Geom Max Score: Life Sci Max Score: Earth Sci Teacher1 Teacher2 Teacher3 Teacher4 Teacher5 Teacher6 Teacher7 Teacher8 Teacher9 205488190 AMADOR, ALEXANDER 4Y6 89.0% 45.5 48 46 42 74 3 56 48 ANDRE LALL JEFFREY GUARASCIO COSMA SHER No Teacher No Teacher No Teacher 274500966 BOBADILLA, MELISSA 4Y6 94.0% 44.1 55 48 42 51 6 32 44 37 ANDRE ESTEVEZ JEFFREY RAY RAMNARINE ANDRE No Teacher No Teacher No Teacher 206314254 NILES, NIGEL 4Y6 100.0% 46.1 57 53 62 70 5 17 53 43 ANDRE LALL JEFFREY STEINFELD COSMA ANDRE JACKSON No Teacher SULLIVAN 207425158 SINGH, AMANPREET YZ6 50.0% 42.5 48 47 56 75 1 63 60 33 ANDRE ESTEVEZ JEFFREY FOUNTOULIS BRAVO RAMIREZ ANDRE JACKSON No Teacher SUTTON 231851064 CABRERA, SELYS 4V6 96.0% 49.1 73 71 84 69 1 51 73 ANTINORA FERMAGLICH FOUNTOULIS TAVERAS No Teacher WOLF EPSTEIN GIRON SANCHEZ 209884477 CHATTERGOON, HARLEY 4N6 94.0% 44.6 77 75 66 69 1 44 66 58 ANTINORA TEZER No Teacher KHAN FOUNTOULIS GARRETSON DOWNS RAY LUPO 205618689 CHOPRA, DANIEL 4N6 89.0% 49.1 93 83 70 83 1 62 77 73 ANTINORA TEZER FOUNTOULIS DIBENEDETTO MASSEY No Teacher CONWAY RAY SANCHEZ 205272909 DELACRUZ, RICHARD 4N6 96.0% 46.5 89 91 93 83 1 66 83 91 ANTINORA TEZER FERMAGLICH KHAN LUPO GARRETSON No Teacher VINE SULLIVAN 234840999 DILIPCHAND, WAZEER 4N6 94.0% 42.5 73 76 66 64 3 67 58 ANTINORA WOLF WALLACE DIBENEDETTO No Teacher RAMOO DOWNS SULLIVAN CHEN 205413529 FERNANDEZ, ANNY 4D6 93.0% 53 78 67 71 74 1 40 73 60 ANTINORA SULLIVAN MARTI MUNOZ SHABANA DOWNS GARRETSON No Teacher SANCHEZ SOLOMON 220491344 GOBINRAJU, RESHMA 4F6 97.0% 51.6 75 75 81 69 3 73 57 ANTINORA GARRETSON No Teacher WALLACE LUPO RESTIFO AMALFITANO ENG VAC A SANCHEZ 205413263 HASNAIN, SAMID 4F6 75.0% 41.1 80 78 85 86 2 72 84 77 ANTINORA NARAINE NARINE DIBENEDETTO DOWNS RAY No Teacher CONWAY KLETZKIN 207995374 KISSOON, RYAN 4I6 100.0% 48.6 82 85 84 82 2 75 81 78 ANTINORA GARRETSON ZAZZARINO No Teacher MEDITZ SAMUELSEN FERMAGLICH WATSON WATSON 204284111 MELENDEZ, SANDY 4N6 61.0% 44.4 78 65 66 68 2 65 55 ANTINORA GARRETSON DOWNS MORRISSEY BRAVO RAMIREZ No Teacher RAMNARINE RAMOO KARABELAS 204286322 SINGH, ANDREW 4N6 100.0% 47.9 85 71 75 82 1 66 88 67 ANTINORA GARRETSON No Teacher SULLIVAN DOWNS ABBRUSCATO ENG VAC A LUPO SHABANA 221959299 AGUIRRE, MIOSOTIZ 4V6 83.0% 46.5 68 59 73 78 4 72 APONTE CHEN No Teacher SCAROLA KARMODY RESTIFO CHEESEBORO CONWAY WILTSHIRE 231053547 BABU, BLESSY 4V6 96.0% 48.5 75 78 67 79 2 80 APONTE GARRETSON CHEESEBORO EPSTEIN No Teacher SAMUELSEN ABBRUSCATO MASSEY DOOBAY 228336095 BATISTA CABRAL, YUDELI 4V6 59.0% 36.7 77 65 70 75 3 69 APONTE KUSHNICK FERMAGLICH LARAQUE No Teacher ENG VAC A VINE SOLETI FEISER 208717066 DIAZ, REYMI 4V6 95.0% 47.5 66 65 70 76 3 73 APONTE SAMUELSEN No Teacher LUPO SAMUELSEN WOLF VINE MARTIN FERMAGLICH 216459685 HERNANDEZ, SABRINA 4W6 92.0% 46.1 77 70 65 82 5 63 69 APONTE FERMAGLICH KARMODY No Teacher KUSHNICK ENG VAC A MEDITZ ROSSIELLO DOOBAY 214605032 LOUISSAINT, TEDY 4V6 93.0% 47.5 68 71 74 3 76 APONTE SAMUELSEN SANCHEZ MONTAN No Teacher RAY SOTIRYADIS CONWAY FERMAGLICH 220372197 MAGALLANES, BOLIVAR 4V6 97.0% 42.5 66 57 77 78 2 66 APONTE SOTIRYADIS No Teacher SCAROLA FOUNTOULIS EPSTEIN FAHY MASSEY KHAN 223499286 MARTINEZ, MIGNOLIA 4W6 95.0% 50.5 75 65 81 72 2 48 72 APONTE SCAROLA NARINE TAVERAS No Teacher WHALEN CONWAY SANCHEZ MASSEY 232154906 SINGH, GAGANPREET 4V6 94.0% 44.5 77 73 69 77 3 59 68 APONTE GARRETSON NARINE LUPO ABBRUSCATO No Teacher KUSHNICK HERAS CAMPOS FERMAGLICH 233838143 ALFARO HERRERA, GEORGINA 4B6 70.0% 51.1 38 63 81 5 55 BISWAS SOTIRYADIS No Teacher TAVERAS PHULESAR FERMAGLICH JONAS CAMACHO K SULLIVAN 206656118 KAUR, RAMANDEEP 4L6 98.0% 46.9 31 47 41 70 4 55 59 BISWAS PHULESAR BRAVO RAMIREZ MADIGAN ROGERS MONTAN No Teacher MEJIA FERMAGLICH 208377507 MUNASSAR, SALEH 4L6 98.0% 42.1 52 65 50 69 1 47 60 BISWAS PHULESAR KHAN MADIGAN RAMIREZ MAR MEJIA No Teacher BRAVO RAMIREZ FERMAGLICH