Mail Label with no duplicate customer names

[njload]

Hello, I am working with an orders database and want to build a mailing label query that will not print duplicate labels.

In the query I have the customer address book and the orders table. I know how to create the query to filter the year I want but how do I add the customer information as to not duplicate the customers and waste labels?

Example:

Order Date Year: ([Order Date]) Last Name
Orders Addressbook

I want to be able to bring up all sales for 2014 but have no duplicate last names.
Hope this makes sense.

 

[plog]

You would use the GROUP BY clause. Click the Sigma/Summation symbol in the ribbon.

When that doesn't work, post the results that are showing incorrect, be sure to include all the fields and their names that you are using in the results.

 

[njload]

Plog, got it to work as needed. I just had rearrange the tables I needed to use and as you suggested use the GROUP BY clause.

Thanks for your help