deleting orphans

J

JethroUK©

i'm struggling to delete some 50-60 student records from a one (students) to
many (qualifications) query - the orphans are the students without a qual

only way i can find these students is to include quals side, produce all
students and search for nulls (QualID) - but it wont let me run a delete
(because there's two tables in the query)?

help!
 
D

David Cox

I believe that you identify the records to be deleted by using a query in
the where clause and NOT EXISTS keywords.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

delete orphans from one to many 5
Number of Students Completing a Qualification for a Date Range 1
Enrollment Database Query help Needed - Low Enrolled classes only 5
Find Record from Subform 3
Query not updateable in Access 2000 1
Design assistance needed (badly) 7
Student Database for Course Enrollments 7
Populating the many side of a 1 to Many relationship 2

Top