Recent content by michaels

Everything done as you suggested. Thanks once again. (y)

OK thanks I will do that. I will normalise the data as suggested then get the maxid. Thanks

We have a table of customers and per each customer there are 68 columns that represent each manufacturer a bit like the picture below. 66N,ABF,ADI etc each represent the manufacturer and the no of orders by customer for that particular manufacturer. We have another table called Manufacturers...