[AccessD] query question

Susan
Can you use two queries ?
1) qryCDFN
SELECT DISTINCT schools.district, schools.grade
FROM schools
WHERE (((schools.grade) In ("C","D","F","N")));
2) qryAorBonly
SELECT DISTINCT schools.district
FROM schools LEFT JOIN qryCDFN ON schools.district = qryCDFN.district
WHERE (((qryCDFN.district) Is Null));

Regards
Mike Tope

----- Original Message -----
From: "Klos, Susan" <Susan.Klos at fldoe.org>
To: <accessd at databaseadvisors.com>
Sent: 03 February 2003 17:42
Subject: [AccessD] query question


> I need to query a table that lists districts, schools, and the school's
> grade.  I need to find only those districts that have A or B schools only.
> No C, D, F, or N schools.  Any help will of course be greatly appreciated.
>