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.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories