Display Report as a Calendar Help

[jice89]

Im creating a database that does scheduling. I've made it so that each day and class are a unique row. IE..Ceramics is offered M-W from June 1st until June 14th. There would be a unique record for each day, so four records on June 1, 6, 8, and 13. I want to display this data on a calendar to be able to be printed out. Now each student will have multiple classes for each day. Is there an easy way to go about this? I can get the information that I want on the report but I can only get it display in the block/list format. Any help would be great! Thanks!

[ajetrumpet]

calendars are difficult in Access. there's no way around that. Active X controls are not, but what you want is. start here: http://www.google.com/#hl=en&sugexp=...6f6ce8c32f4f53

Again, like many posts here, the method to get it done completely depends on what you need in the end. You say a calendar, but you're not giving any specifics. WHAT should be on the calendar??

for instance:

• the classes to be taken each day, as a whole
• students attending classes on each day
• etc...

obviously a calendar is day-by-day, but regardless, this:

I've made it so that each day and class are a unique row.

should not need to happen. that is un normalized data, which is not common in database worlds.

not sure I'm exactly right on that, so check the google link to see if there are more ideas there.