Query multiple records

Table/Fields

Students/ Student ID, First name, last name....
Tests/ Student ID, Test Name, Test Score, Test Date.

I need to be able to find students based on their record of tests. For example I need to find each student who got above a certain score on 3 or more tests consecutively and within a certain time period.

In one to many relationships I have no idea how to find the one by querying the many related to it. I am new to access and any help would be appreciated greatly.

Chaos

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com
.

Relevant Pages

  • Re: Need to normalize to 2nd form.
    ... purpose in the student table), the Test Name or Test ID (I'll get to ... that in a second), and the test score. ... 6th grade Math teacher ... Perhaps my cosultant meant that I should not be populating those ...
    (comp.databases.ms-access)
  • Re: Need to normalize to 2nd form.
    ... I have a student info table using a student ID number as a primary key. ... Test Score #1 ... 6th grade Math teacher ... I'm a noob seeking advice here. ...
    (comp.databases.ms-access)
  • Need to normalize to 2nd form.
    ... I have a student info table using a student ID number as a primary key. ... Test Score #1 ... 6th grade Math teacher ... I'm a noob seeking advice here. ...
    (comp.databases.ms-access)
  • RE: Wrong Info on Group Query
    ... Try just sorting the 2nd column. ... "Leona Leal Educator" wrote: ... test score I get the student som place in the middle. ...
    (microsoft.public.access.queries)
  • RE: Wrong Info on Group Query
    ... "Golfinray" wrote: ... "Leona Leal Educator" wrote: ... test score I get the student som place in the middle. ...
    (microsoft.public.access.queries)