I have a weird issue - one that I've never had to deal with before...I was hoping someone could give some ideas of how to tackle it....

I have a table with departments, rooms, and tables - each room has 1 or 2 tables.

I want to report on this information, but in a horizontal way. In other words, the table column 1 would contain the first dept, the second column the 2nd dept, etc...

The first row would be the dept name, then the room, then table(s), etc.

But having one recordset with all that data seems hard to output the data in this way, because the data is in rows in the recordset.

I could have a recordset for each room, but then I'd have hundreds of recordsets.

Does anyone have a clue what I'm trying to say?

In other words here is my recordset:
Row1: Finance, Room1, Table 1
Row2: Finance, Room1, Table 2
Row3: Finance, Room2, Table 1
Row4: Facilities, Room1, Table 1
Row5: Facilities, Room1, Table 2
Row6: Facilities, Room2, Table 1
Row7: Facilities, Room2, Table 2

But I want the data outputted like this:
FINANCE FACILITIES
Room 1 Room1
Table 1 Table 1
Table 2 Table 2
Room 2 Room 2
Table 1 Table 1
etc...

Am I doomed? This seems hard to do with ASP and HTML....

Any help appreciated!

Thanks-

Actually, it's not that difficult.

Couple of questions:

1. on a scale of 1 - 10, how familar are you with .ASP (not the stuff DW writes, but hand writing the code)?

2. Do you want the datasets displayed forever and ever infinitum from left to right or do you want, say, 3 rooms per line?

Doc
Rangewalk Digital Studios

Edited by - on 05 Jan 2003 07:02:28

Well,

Yes, I know ASP very well....I've actually figured this problem out already - but I'm curious what you had in mind.

Thanks-