Building a Resource Scheduling Database Version: 2000 (9.0)

[trypsin4ever]

Hello --

Can Access develop a report in Excel with shaded areas to denote a used resource for a given timeframe?

I am building a database that will hold schedules for Trainers and Training Rooms, along with other related training class data. I'm looking to develop an excel report that will display the 52-weeks of the year down column A, and the classrooms across row one. Cell would be color-coded vertically by department.

I've attached an example:

I have a class beginning on January 1st and ends on February 28th, in Classroom C. I want Access to generate an Excel spreadsheet that will color the cells from 1/1 to 2/28 under Classroom C.

Any help would be greatly appreciated. Thanks!

Gabe

 

[pbaldy]

The short answer to your question is yes. I built an app that visually displays limousine and bus reservations for a given day (more intricate than what you're attempting). You will need to bone up on "automation", so search on that. Basically it's a way to deal with Excel from Access but with a lot more control than simply exporting data.