Using Access to create calendars

[donahuem]

Hello.

I've been beating my head about how to do this, first with Excel pivot tables, second with Access cross-tab queries. Alas....

Can someone please tell me how I can create an Access or pivot table report with TEXT in the row/column intersections instead of data sums or counts? I'm trying to create a calendar with student names as the row headers, calendar months as the calendar headers, and instructor names, locations, etc. within the grids.

I can create reports with the months aligned vertically, but can't seem to align them horizontally without losing my data. Argghh! Please help!

Thanks and best wishes,

M

 

[donahuem]

No suggestions? Please...?

I know this may seem like a job for Outlook, but it's not for various reasons, and what I'm looking for is so simple.... Please.

Best wishes,

Matt

 

[trickg]

I feel your pain! I'm trying to do something similar. I have no problem entering the data and I have the tables set up so that I can track events and people, but I can't figure out how I'm going to display the data in the end.

ARG!

 

[Cosmos75]

Helpfull... maybe?

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=48893&highlight=calendar