matrix display

[radujit]

Hi,
I have a tabel in access db fx(bank,currency,operation(buy or sell).
I created 4 recordsets that pick data as follows:
recordset1 (Bank, EUR, Buy)
recordset2 (Bank, EUR, Sell)
recordset3 (Bank, USD, Buy)
recordset4 (Bank,USD,Sell).

Now I want the data to be dispalyed using classic ASP on a page as follows:

Bank EUR-Buy EUR-Sell USD-Buy USD-Sell
recordset1 recordset1 recordset2 recordset3 recordset4

More specific:


Code:
in the original table in database:


ID Bank Transaction type Currency Value
1 X Buy EUR 1
2 X Sell EUR 2
3 X Buy USD 3
4 X Sell USD 4

Data in the ASP should be displayed as follows:




Bank EUR - Buy EUR - Sell USD-Buy USD-Sell
X 1 2 3 4


Thank you in advance.

[goldengel]

Hi radujit

Please, what exactly is your question?
Perhaps this helps: http://www.w3schools.com/ado/ado_recordset.asp

Regards