Duplicate Entries on database

[Guest]

Hi
i have a customer database for a garage - some of the customers are entered
on twice due to them having different cars ect, what i need to do is a
mailing letter only one per household/business. I do a query and its
repeating the customers. I dont need repeats in the same house/business but
it has to allow repeat surnames for obvious reasons. Does anyone have any
ideas please.
many thanks

 

[Jeff Boyce]

Pammi

Once you have a query that returns all possible mailing label data
(including duplicates), convert the query to only show Unique Values. You
can do this through the query's Properties.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Guest]

Hi Jeff
could you tell me where in the properties i find the unique values please or
where i put it. im a bit of a newbie picking my way through.
many thanks

 

[Jeff Boyce]

Pammi

One way to see the properties is to open the query in design mode, click the
View menu and the Properties item, then click in the open grey space in the
top window. The list of query properties should include a Unique Values
property.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Jeff Boyce]

The Unique Values property is exactly that. If your query includes
vehicles, Mr Jones will show once per vehicle. Remove the "more than one
of" items from your query ... after all, you only need the address portion
for your labels, right?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/