query help

  • Thread starter Thread starter Gary B
  • Start date Start date
G

Gary B

I have a MASTER-DETAIL (one-to-many) relationship.

If I do a JOIN, how can I return just ONE CHILD for every master?

Thank you.
 
Which Child record do you want? If it doesn't really matter which one,
make it a Totals Query (select Totals from the View menu in query design
view), leave Group By in the Totals row of the query design grid for the
relevant field(s) from the Master table, and enter First or Last in the
field from the Child table.
 
Back
Top