I'm working on a timetable. Naturally the database table contains the date code, subject code, lecturer code, etc. How can I get this tree looking timetable into a columnar table with the days spreading to the right. I can get the Pivot Table view but it's not as flexible as Excel.

Thanks for the prospective thoughts!

Maybe a crosstab query broken up by day would work.



Sal

Hi Sal,

Thanks for the idea, I didn't use the crosstab query before. Tried it only to find that it gives me the 'sum' or 'count' etc. of the subjects. It won't give me the name of the subject, though a data access page could do that.

Another thing: If there is a way of getting the subject names shown, could I have it transferred onto a report (without much coding)

Thanks...

Are you referring to the column names?




Sal

Yes.

And, by the way, one correction. I think I've been using the term 'column' in the wrong way. Should have said "tabular" I believe.. Sorry. I have tried to create a report using a wizard and it worked fine. But the days, or the classes will change, and the design of the report will need to be changed as well...

Thanks

Murat