Results 1 to 4 of 4
  1. #1
    antinora is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    8

    Newbie Question

    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

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    I suggest you read up on Normalization and then restructure your tables accordingly
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    antinora is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    8
    Thanks for the push in the right direction! JA

    Quote Originally Posted by Bob Fitz View Post
    I suggest you read up on Normalization and then restructure your tables accordingly

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I agree with Bob. I also recommend that you work through this tutorial from RogersAccessLibrary (~ 45-60 minutes).
    You have to work through it, but you will learn and what you learn can be applied to any database.
    It starts with a problem description; leads you through a procedure; and results in a database structure that meets your requirements. And it does have a solution included.
    The Hernandez method is a great resource/reference also.

    Here is the start of articles on Normalization by Roger Carlson.
    Good luck with your project.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. newbie question
    By pacaskurban in forum Access
    Replies: 4
    Last Post: 04-09-2015, 03:28 PM
  2. Newbie question please help
    By Napier in forum Access
    Replies: 1
    Last Post: 11-28-2011, 09:00 AM
  3. Newbie question
    By Patience in forum Queries
    Replies: 4
    Last Post: 11-24-2010, 02:18 AM
  4. Question from a newbie
    By scarps626 in forum Access
    Replies: 2
    Last Post: 10-02-2009, 03:40 AM
  5. Newbie question
    By The_Dude in forum Programming
    Replies: 2
    Last Post: 12-23-2007, 07:11 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums