Need a select query

[Guest]

I have a table with three fields (among others): num, inb, and del. The key
is a combo of num and del. In this table, it should not be possible for a
record to have a particular value for num (say X), a value for inb, and a
null value for del, if there also exists another record in the table with the
same value X for num, and values in both inb and del. I want to select these
illegal records and delete them. The query should filter the records to show
only records where del is null, with the value of num the same as other
records where inb and del are not null, and then delete those records.

 

[[MVP] S.Clark]

You can select the records for display in one query(or display on a form),
then use a second query that performs the delete.