qry help requested

[Bri]

Hi - I'm new at Access and would appreciate some assistance:

I have a table (tblStudents) with athID and athEmail along with other
fields. Another table (tblClass) has fields athID and classID. The
classID's run from:

100 to 299 in the Fall
300 to 499 in the Winter
500 to 699 in the Spring

I want to send an e-mail message to all athletes who registered in either
Fall or Winter, who have NOT yet registered in Spring.

For example 'adamac' registered in all three sessions, so no e-mail.
'bermal' registered in Fall and Winter only, so she gets an e-mail, but only
one.

Could someone show me how to set up this qry showing athID and athEmail for
those who need to get the message?
Thank you, Bri

 

[John Vinson]

Hi - I'm new at Access and would appreciate some assistance:

I have a table (tblStudents) with athID and athEmail along with other
fields. Another table (tblClass) has fields athID and classID. The
classID's run from:

100 to 299 in the Fall
300 to 499 in the Winter
500 to 699 in the Spring

I want to send an e-mail message to all athletes who registered in either
Fall or Winter, who have NOT yet registered in Spring.

For example 'adamac' registered in all three sessions, so no e-mail.
'bermal' registered in Fall and Winter only, so she gets an e-mail, but only
one.

Could someone show me how to set up this qry showing athID and athEmail for
those who need to get the message?
Thank you, Bri

You'll need to create a Query based on tblStudents; put a criterion on
AthID of

IN(SELECT athID FROM tblClass WHERE ClassID BETWEEN 100 AND 499)
AND NOT IN(SELECT athID FROM tblClass WHERE ClassID BETWEEN 500 AND
699)