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
Last activity: Jul 16, 2015, 10:06 PM