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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Subrecords

Status
Not open for further replies.
beec

beec

Programmer
Apr 3, 2002
13
0
0
GB
I have an Access XP application with a master table and related records in a subtable.
How can I filter wich records in my master table have no subrecords in the subtable.
The tables are linked with an ID field in the master table.

Thanks,
BE
 
Sort by date Sort by votes
Do a left join and then select records where there is a null value in one of the fields of the 'subtable'. It doesn't matter which one you choose.

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

DarthWHO
  • Locked
  • Question
Copying Record with Subrecords
Replies
0
Views
13
DarthWHO
DarthWHO
drazeni
  • Locked
  • Question
Display record and subrecords if exists, after primary key entry
Replies
1
Views
22
mac318
mac318

Part and Inventory Search

Sponsor

Back
Top