The charity we're helping currently holds volunteer info in an Excel spreadsheet. This holds information about which volunteer helped out at a particular sector on a charity walk. My wife and I are in the process of helping them move this to an Access DB.
Because the walk starts at midnight, there are a number of families which marshall the same sector - so the spreadsheet name and address data contains example like 'Steve, Linda and Mathew' in the 'firstname' field of the name and address. While it's easy to split these into separate people to hold in the DB, the address labels report will then produce three labels, one for each of these people who all live at the same address.
In design terms, is there
a) a way (simple, easy!) to allow only one label to be produced for a family
can it be made to allow separate labels if required (e.g. if the family decides they are prepared to marshall at separate sectors)?