This message serves for Google indexing. It only includes the first message of each thread from technical forums. To see the entire thread, the solutions and the technical content related to each message, you need to log in by going to the main page. This can be done at http://www.universalthread.com. If you do not have an account, we encourage you to create one now and start participating in Microsoft .NET and SQL Server related technology forums, just to name a few. Our database contains nearly two millions valuable high end technical messages. Thanks for the generous contribution to everyone who participated on the site so far, including MVP, Microsoft employees and many other well known contributors. The valuable content of the Universal Thread has created a history of 16 years of high end technical content which has helped many consultants, developers and many others in the industry on a daily basis. The site also offers a subscription option that greatly enhances your site experience.


View message
From09/07/1997 10:11:16
Elyse Pomerantz #011150
Dynamic Data Concepts, Inc.
Brooklyn, New York, United States
To  
All


I'm setting up a reporting module and I ran into the following problem. I have a SELECT statement that selects records from several files, each record distinct. For example, one file contains names, another addresses, another phone numbers, and another clubs that they belong to. The SELECT statement creates a table using all of the files, so a person may be listed several times if they belong to several clubs or have multiple phone numbers. The user can then choose which fields they want to print on a report or label. The problem arises when they choose only fields such as name and address. I don't want to print multiple labels with the same name and address. Even though the records in the table are distinct, the limited fields that were chosen to print are not. How can I get the label to print only one record if the chosen fields are duplicated?

Thanks for any help,
Elyse
Elyse Pomerantz