I use Access for my school. I have families with the same last name. Reports are not showing repeat names even though each family has diff. ID's. I have for example 2 Rosenbaum families with 2 children each. The report will print one name (1st in the alphabet) with 4 children.
How do I tell Access to allow duplicate names?