If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Duplicate Entries on database
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 |
#2
|
|||
|
|||
Duplicate Entries on database
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 http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ Microsoft Registered Partner https://partner.microsoft.com/ "Pammi J" wrote in message ... 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 |
#3
|
|||
|
|||
Duplicate Entries on database
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" wrote: 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 http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ Microsoft Registered Partner https://partner.microsoft.com/ "Pammi J" wrote in message ... 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 |
#4
|
|||
|
|||
Duplicate Entries on database
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 http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ Microsoft Registered Partner https://partner.microsoft.com/ "Pammi J" wrote in message news 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" wrote: 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 http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ Microsoft Registered Partner https://partner.microsoft.com/ "Pammi J" wrote in message ... 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 |
#5
|
|||
|
|||
Duplicate Entries on database
Ok i have found that and set unique value to yes - but its still showing
duplicates - ie Mr Jones - High Street Mr Jones - High Street He has got 2 different vehicles but he only needs one mailshot letter for both cars. how do i get him and other customers with more than one vehicle to show up only once so i can send a letter. "Jeff Boyce" wrote: 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 http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ Microsoft Registered Partner https://partner.microsoft.com/ "Pammi J" wrote in message news 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" wrote: 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 http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ Microsoft Registered Partner https://partner.microsoft.com/ "Pammi J" wrote in message ... 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 |
#6
|
|||
|
|||
Duplicate Entries on database
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 http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ Microsoft Registered Partner https://partner.microsoft.com/ "Pammi J" wrote in message ... Ok i have found that and set unique value to yes - but its still showing duplicates - ie Mr Jones - High Street Mr Jones - High Street He has got 2 different vehicles but he only needs one mailshot letter for both cars. how do i get him and other customers with more than one vehicle to show up only once so i can send a letter. "Jeff Boyce" wrote: 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 http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ Microsoft Registered Partner https://partner.microsoft.com/ "Pammi J" wrote in message news 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" wrote: 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 http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ Microsoft Registered Partner https://partner.microsoft.com/ "Pammi J" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|