I have a table of family members with addresses and tel nos.
Plus a table with eldest child with date of birth, these are related by an ID No.
I created a query to link the two which shows the members of each address sorted by age.
Query works everything OK, however when I run a report based on the query two of the families duplicate themselves all others are OK.
How can this happen?