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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to eliminate duplicate value from displaying in query result 4
Count Distinct in a crosstab 2
Can subquery do it ? 3
Query for Multiple Lookups 2
Access 2007 replica to master 4
MASTER -> DETAIL {the last row entered ordered by Date then PrimaryKey} 6
Specific Detail Table Row 1
One-to-Many join act as a One-to-One join 2

Back
Top