duplicate records in a report

[b9791]

I have a table that stores records based on a category and subcategory. SOme contacts may be stored in more than one subcategory and still be in the same parent category. I want to be able to print off a label report that will eliminate these duplicates within the category. I think I should be using SELECT DISTINCT but I don't know exactly how to use it. Any help would be greatly appreciated.

By the way, the query is currently pulling city and state data from a zip code table and I am pulling the Category Name from the category table as well as the main table that has all other contact information on it. Thanks again.

Brian

 

[Matthew Snook]

Brian:

First create your query which combines your Contact, Category, and Address information so you have fields:
Category, Subcategory, Name, Address, Zip, etc.

Then, "Select Distinct" would work simply by leaving the subcategory field out of your report query.

Select Distinct Category, Name, Address, etc., from FirstQuery;

would give you each name within the category only once, assuming that there is only one address etc. for each name. For a label report you probably don't even want the "Category" field printed, so you can leave it out also.

Matthew

 

[b9791]

thank you

I will try that