SQL statement to only display certain criteria 1

[usagi75]

If I have say this table

MemID Training Type Hours
----- ------------- -----
1 Training 2.5
1 Training 2.5
2 Access 3
1 Access 1.5
3 Training 2.5
2 Training 2

With the above data, only Member 2 has done "Training" only. What SQL statement do I need to only show the members that have done training only?

 

[usagi75]

Oops...I meant only Member 3 has done "Training" only

 

[dhookom]

Considering your data, you could try.
SELECT *
FROM tableA
WHERE MemID Not IN (SELECT MemID FROM TableA A WHERE A.TrainingType ="Access")

Duane
MS Access MVP
Find out how to get great answers faq219-2884.