Query multiple record

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: begin traversal at the end of a list?
    ... student writes: ... By introducing an additional argument that is used to report solutions ... this kind of querying can be delegated to the toplevel: ... comp.lang.prolog FAQ: http://www.logic.at/prolog/faq/ ...
    (comp.lang.prolog)
  • Query multiple records
    ... Tests/ Student ID, Test Name, Test Score, Test Date. ... In one to many relationships I have no idea how to find the one by querying the many related to it. ... EggHeadCafe - .NET Developer Portal of Choice ...
    (microsoft.public.access.queries)
  • Need Help
    ... 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. ... EggHeadCafe - .NET Developer Portal of Choice ...
    (microsoft.public.access.gettingstarted)
  • Query multiple records
    ... 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. ... EggHeadCafe - .NET Developer Portal of Choice ...
    (microsoft.public.access.gettingstarted)
  • Re: combining queries
    ... Perhaps a third table lists all the "semesters" or other time ... show which classes are available in each time period. ... are taken by each student in each time period. ... You could then query to arrive at the billable units, ...
    (microsoft.public.access.queries)