Extract Data

[mousemat]

OK, so i have finally got round to re-building my client's database as suggested several times by RV.

I have three main tables that I need to extract data from - tblMembers, tblModules, tblCompleteModules.

Basically its a database containing the training details of Scout Association leaders. Each Leader needs to complete 26 modules over a period of time.

tblCompleteModules contains the data for the modules that have been completed, MemberID, ModuleID Date Completed and CompletedID.

I know how I can extraxt the modules that members have completed, but how can i extract the data for the modules that have not been completed. For example I need to report on the number of people who haven't completed module number 20 for example.

Any ideas?

 

[pbaldy]

One way:

SELECT *
FROM tblMembers
WHERE ID Not In (SELECT MemberID FROM tblCompleteModules WHERE ModuleID = 20)

 

[mousemat]

Thanks Pbaldy. Works a treat