query help

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.
 
S

Steve Schapel

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.
 
Top