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

Record Selection criteria problem

Status
Not open for further replies.
pbateman

pbateman

Programmer
Joined
Jul 6, 2004
Messages
58
Location
GB
I want to limit the rows returned from a table (Parent) by the content of a Child table's field or if the Child does not contain a row linked to the Parent table. The Child is joined to the primary key on the Parent table. I am using version 8.5.
 
Sort by date Sort by votes
Make sure your join is set as an Inner Join.

 
Upvote 0 Downvote
I've sorted it now thank you.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dovl
  • Locked
  • Question Question
presenting all records that meet a condition plus the first record only that does not meet the cond
Replies
1
Views
980
lbass
lbass
sal21
  • Locked
  • Question Question
create report without database in vb 6.0 and recordset
Replies
0
Views
995
sal21
sal21
lm1340
  • Locked
  • Question Question
How to only get records that have data in at least one of many tables
Replies
2
Views
1K
lm1340
lm1340
Almie
  • Locked
  • Question Question
Display record with identical field data
Replies
2
Views
347
hilfy
hilfy
DJWheezyWeez
  • Locked
  • Question Question
Dynamic parameter not showing every record
Replies
1
Views
276
PeterDimitrov
PeterDimitrov

Part and Inventory Search

Sponsor

Back
Top