Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Unmatched Records

Status
Not open for further replies.
mariosm

mariosm

Programmer
Dec 28, 2000
4
GB
I have 2 linked tables. The Master has had some records deleted from it. How do I now find the unmatched records in the secondary table so that I can now delete those.
 
Sort by date Sort by votes
Hi
Go to queries and run the FIND UNMATCHED It will ask you for specifics and then givve you the result.

hth
Bastien

There are many ways to skin this cat,
but it still tastes like chicken
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

blueman124
  • Locked
  • Question
All records not showing in access table that is linked to sharepoint list
Replies
0
Views
103
blueman124
blueman124
Moss100
  • Locked
  • Question
Turn one to many relationship into single records 2
2
Replies
34
Views
339
Moss100
Moss100
bobjackson
  • Locked
  • Question
Selected records write to table with field based on percentage of selected records
Replies
5
Views
113
bobjackson
bobjackson
JanBS
  • Locked
  • Question
Append records to table based on a changing variable 1
Replies
10
Views
166
JanBS
JanBS
Moss100
  • Locked
  • Question
Deselecting records from a query result and saving remaining records
Replies
1
Views
57
MajP
MajP

Part and Inventory Search

Sponsor

Back
Top