Help with a TOP query

[jasonphillipstx]

I have 2 tables

FAMILIES
FamilyID, Mom, Dad

CHILDREN
FamilyID, FirstName, Birthday

I have a query on the children table that selects children under age 11
qry_Kids_Under_11 returns the following columns
FamilyID, FirstName, Birthday

I want to list the families that have kids under age 11 so I can send them a postcard, but many have several kids under 11 and I do not want to send multiple cards to each family.

I hve tried several methods but get incorrect results. thanks in advance.

 

[PHV]

Have a look at the DISTINCT predicate:
SELECT DISTINCT F.FamilyID, F.Mom, F.Dad
FROM FAMILIES AS F INNER JOIN qry_Kids_Under_11 AS K ON F.FamilyID = K.FamilyID

Another way is an aggregate query.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886