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.