[AccessD] Avoiding Duplicates on a Report

Hi Mike
I think you can do it without concatenation anyway. Assuming you have the
required product code as, say, a parameter [Product] then you can do a query
like:

SELECT DISTINCT Tbl.Customer, [Product] AS ProductCode
FROM Tbl
WHERE Tbl.Pr1=[Product] OR Tbl.Pr2=[Product] OR Tbl.Pr3=[Product];

I've only gone to 3 product code fields but you get the picture.

--
Andy Lacey
http://www.minstersystems.co.uk



________________________________________________
Message sent using UebiMiau 2.7.2