Sorting a Report 1

[dcmedic]

I've been having trouble sorting and displaying a report on the LastName field. The report is designed to display families sorted by their last names and then display the names of their children.

When I sort by the last name and there is an identical last name, only one is displayed, yet the children of both families are listed underneath. Any suggestions?

dcmedic@cablespeed.com

 

[JoeMiller]

Change your sorting to be by LastName but your grouping to be the unique id for each family. Access thinks that because they have the same last name, they belong together.

HTH Joe Miller
joe.miller@flotech.net