Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Wed Jun 21 09:45:55 CDT 2006
Martin: I'd process the list with a bit of code and create a temp table with the text you need, rather than try to make the queries jump through that hoop. Although I'm sure it could be done quite cleverly with queries and report features. I'm just much better with code than queries and find it takes a lot less time to make temp tables for oddball reports. Rocky Martin Reid wrote: > Given the following data > > 1234,Name,Address > 1234,Name,Address > 1234,Name,Address > 1234,Name,Address > 2345, Name Address > 2345,Name Address > > I need to get one mailing label produced > > 1234, Name1, Name2,Name3,Name4 > Address > > 2345,Name1,Name2 > Address > > Etc > > So I can have multiple people at the same address. I need the name line to include all the names but only produce 1 label per address. > > Martin > > > Martin WP Reid > Training and Assessment Unit > Riddle Hall > Belfast > > tel: 02890 974477 > > -- Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com