|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
I have one large table conssiting of students with records that utilize the a Student ID # (text) to distinguish them from one another. Each record in this table simply consists of a StuID# and the class they have taken for that quarter (ie. English 2). A StuID# may appear many times in this table to identify each class being taken (upwards of 10 records for any one StuID#. There is another table of similar design but it contains StuID#s that are no longer valid (they left or dropped out etc.) How can I delete the (potentially multiple) records in the larger table that exist in the smaller table.
Big Table A Small Table B StuID# Class StuID# Status K123 Eng 1 G654 Dropped K123 Eng 2 F111 Postponed K123 Eng 3 G654 Ger 1 G654 Ger 2 G654 Eng 1 G654 Eng 2 G654 Eng 3 F111 Fr 1 F111 FR 2 F111 Ger 1 Z1 Ger1 So what I want to do is eliminate G654 and F111 located in Small Table B from Big Table A. I know how to create the unmatched query but not how to delete multiple records based upon that query. Please Help |
![]() |
| Viewing: Dev Shed Forums > Databases > Database Management > MS Access How to Remove Records from One Table That Are Unmatched in Another Table |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|