hi, I have the following questions: the new table contain the following C1 C2 C3 10 10 100 10 15 200 10 20 300 20 10 150 20 15 250 20 20 350 I like to show it in the matrix form as 10 15 20 10 100 200 300 20 150 250 350 I had tried to put them in the matrix form, it comes out like 10 15 20 10 15 20 10 100 200 300 150 250 350 10 100 200 300 150 250 350 10 100 200 300 150 250 350 20 150 250 350 … 20 150 250 350 … So the problem i face is the form will repeat each value the records appear. I had read the item by location form. Since item table and location table contain the unqiue values, they don’t have this problem. Please help how to isolate the dupliate value. Regards, Rich
The easiest would be to create another table(s) which are holding your your horizontal and vertical values and take your current table just for calculating the value in the matrix itself. Just an info: I do not really understand how you get from your table to the matrix you want to show :S
tsang, can you try to clarify the conversion you are trying to make, are ABC the primary keys of a table?