Incredible. I dropped your code into a module as-is. I'm no SQL expert, but managed to modify your sample SQL properly. It worked the first time.
Many thanks, Duane!
Dave Lamb
Thanks Duane. That works nicely to pull out just one row per address. I wasn't clear about the desired outcome. I want to create a label that includes all of the appropriate names as well. Thus, I have one record for David Lamb, another for Cheryl Lamb. They are both linked to the same...
I have an Access 2002 database of people (both students and volunteers) involved in an after-school program. I need to create mailing labels for people with certain characteristics. Seemingly a simple operation, but I run into the issue of creating more than one label for the same address if...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.