Sample Header Ad - 728x90

MS Access database returns multiple entries for same person with more than one child

2 votes
0 answers
115 views
I know this is a very basic question, but I've watched about six Access database videos and still can't find the answer. I'm a volunteer creating a membership database for a church in MS Access. The children are in a table separate from their parents. When I query the two tables for the data which I will then use in a Word mail merge, if a person has more than one child, that person will have more than one entry in the query results. - How do I return just one entry for a parent with more than one child? - Is it a Grouping function? This is a basic question, for say a customer database, where a customer has more than one order, but I cannot find the answer. Thank you.
Asked by Amanda Lietman (21 rep)
Jul 16, 2015, 08:45 PM
Last activity: Jul 16, 2015, 10:06 PM