Compile addresses

[simtech113]

Hi,

every month I do a bunch of address labels using our access database, but some people live at the same addresses. Is there any way of making a query so that for people who have the same address I could have First name, surname, &, first name surname, then the address as usual? Rather than making two labels for the same address?

Thanks.

 

[Dennisk]

Your problem is that if 10 people live at the same address you will not have enough room on the line for all the names.

 

[Mike375]

Is this for a husband and wife situation?

 

[simtech113]

Yeah true, but I can't see it happening we only have a small database. Maybe 130 people on it. No it's a work related issue, just saves time and money being able to print one label for each household. If it did get to 10 or similar couldn't I have some sort of claus to get it to do say 2 or 3 labels?

 

[DCrake]

If you grouped by Postcode and counted by post code then you could have the first address line =

Addr1:IIF(PCCount > 1,"The Occupants",Trim([Firstname] & " " & [Lastname]))

David