Query multiple records

C

Chaos Maximus

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
 
G

Guest

Doesn't matter. Create a query that joins the two tables on Student ID and
apply your criteria.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query multiple records 2
Query multiple record 1
Need Help 1
Counting records in a table 5
Compare data of column in many fields. 1
Finding highest values 1
Problem with finding minimum date value for query 1
Comparing fields in a table. 1

Top