I am relatively new to ASP, but I have made a database with hotels and their rates. I want to make a page for 1 hotel which displays the different roomtypes in the rows of one column. In the other columns the period from/to will be mentioned. On the crossings of roomtype-row with the period column, the rates have to be presented.

I have made a cross query in Access 2003 which states exactly the info I want, but the periods are column heads (as you would have in excel). How do I publish a rate grid like this dynamically. Roomtypes, rates and also periods differ per hotel, so I cannot fix one of the elements.