If you've got some leeway on presentation format, I can think of a couple
options:

In Access you could use a Cross-Tab Query and display that data in a report
(You should go to the MS Access forum for help with that, though)

In Excel, you could try using a Pivot Table
I got the following results with practically no work:

Last Name...First Name......Sex.......Children's Names..Total
Smith...........Joe................F..........Mary .....................1
.........................................M........ .Greg......................1
.................................................. ...Joey......................1
Brown...........Marsha..........F..........Cindy.. ..................1
.................................................. ...April.....................1

Would that meet your needs?

--
Regards,
Ron