[AccessD] Avoiding Duplicates on a Report

On 19 May 2005 at 8:54, Gowey Mike W wrote:

>  
> Thanks everyone for the advice, I will certainly look at normalization.
> But for now how do I do about concatenated??  I have not heard of this.
> 

Just a fancy way tyo say "add the strings together".

In this case, use a  Query with the following settings: 

Field: 
Customer
Total:
Group By

Field:
OrderProducts:Product1 & Product2 & Product3 & Product4 & Product5 & Product6
Total:
Expression
Criteria
Like "*" & ProductName &"*"

You will probably want to replace ProductName with something like
Forms!frmProductSelectionForm.cboProductPick






-- 
Stuart