How to pick up a Particular value in a table

[Former Member]

Hi all,

I have the output of a query to display in a table.Now i want to pickup some values from the output table and use them to display in a graph.

I wanted to pick the values as below:

i have 6 rows in the table and 10 columns in the table.

How can i pick the values from the intersection of 2nd row and 8th column,and intersection of 3rd row and 6th column,intersection of 4rh row and 5th column....and something like this...

i wanted to store these values in an invisible form and use them when i require.

Thanks

P.Navakanth

[Former Member]

Self closed

[Former Member]

Hi all,

Please find additional info

Below is the sample table which is the output of query :

Column 1 Column2 Column3

Row 1 180 130 280

Row 2 260 190 320

Row 3 313 125 639

Row 4 257 367 478

I want to display the 4 values in a form which are to be taken from the above table (which are bold).....i.e

value 1 as 280 which is intersection of row1 and column3

value 2 as 260 which is intersection of row2 and column1

value 3 as 639 which is intersection of row3 and column3

value 4 as 367 which is intersection of row4 and column2

Thanks

P.navakanth

[Former Member]

Hi,

If you darg the form form the tabel output port the it si able to display only one row at a Time.

it means the form is able dispaly value1 or value2 or value3 or value4 at a Time.

because form has single ton structure measn it can display one row at a Time.

Govindu