How to eliminate duplicate mailing addresses in a query with 4000 names

[ckoop]

I have 4000 vol for an event listed in a query, most work more than one shift, some as much as 10 shifts. In preparing labels for a mailing of work schedule cards I want to eliminate the multiples going to the same address. HOW

[burrina]

You will need to run a delete query for table(s) and enter your criteria,such as shift(s) and email address.
Hard to say without more details.

[ItsMe]

I would start by building small Totals queries that employ GROUP BY. The trick is to query your table by including the least amount of fields/columns. This is usually done by not including the primary Key. Then you can use your query in another query and join on a field such as Address. Here you will include a Foreign key that can be used as a JOIN for another query that will be the final main query.

[ranman256]

In the query propeties, set UNIQUE VALUES = YES.

[ItsMe]

In the query propeties, set UNIQUE VALUES = YES.

Why would you choose that over GROUP BY or maybe SELECT DISTINCT with an alias?

[bridgeo730]

In the query propeties, set UNIQUE VALUES = YES.

How do you do this?

[isladogs]

SELECT DISTINCT does exactly the same thing as setting Unique Values = Yes

Method 1:
Open query in design view, then set unique values = Yes in the query property sheet

Method 2:
Open query in SQL view.
Replace SELECT with SELECT DISTINCT at the start of SQL statement