Query to display if multiple tests have been passed?

[Terry]

Hi,

I need to devise a query that will diplay student details and exam
details for students who have passed modules 1, 2 and 3, using 1,2&3
and Pass as the criteria but not displaying every record for each
module passed.

Can anyone suggest away to show if students have passed
modules 1, 2 and 3 and get it to look something like:-

Firstname Lastname StudentID Passed1,2&3
Harry Jones 001 Yes
Jenny Baker 002 Yes


StudentTbl contains personal data: StudentID (AutoNumber)(PK),
FirstName (Text), LastName(Text) etc.

ExamTble contains contains details of results: ExamID(AutoNumber)(PK),
StudentID(Number)(FK), ModuleID(Number), Pass(Yes/No), Fail(Yes/No)
etc.

The tables have a one to many relationship.


Thanks Terry

 

[Gerald Stanley]

Terry

I have responded in the original thread to this topic

Gerald Stanley MCSD

 

[Steve Schapel]

Thanks for the tip-off, Gerald. Can you remember where the "original
thread" was?

 

[Gerald Stanley]

Steve

It is in the Forms topic. The thread has the same name as
this one.

Gerald Stanley MCSD