matrix display

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:

Code:

---

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:

Code:

---

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

---

Thank you in advance.

Hi radujit

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

Regards