Help to create a specific format for report

[Fred Boer]

Hi:

I would like some help, please, to create a report formatted in a particular
way. Although I am able to make what I think is a reasonable report, my user
wants a different report that looks a certain way, and I wonder if it is
possible.

This is for an application which is used to manage "sessions" for a school's
"Ways to Work" career information day. It's like organizing conference
sessions. An afternoon is divided into 4 session slots. Each session needs
to have two teachers assigned for student supervision.

I managed through trial and error to successfully create my first crosstab
query/report to list attendance totals for each session, but I can't seem to
make a crosstab query/report that works for this particular report. Reports
are *not* my strong suit...

Thanks for any suggestions! Details are given below that might help
explain...

Fred Boer


So for example:

CareerSession/Location/Slot

Programmer/Room 1/Slot 1
Programmer/Room 1/Slot 2
Policeman/Room 2/Slot 1
Policeman/Room 2/Slot 3
Parson/Room 3/Slot 1
Parson/Room 3/Slot 3

Presenters do between 1 and 4 sessions.

Now, each session gets two teachers. I need a report which looks like a
spreadsheet grid, like so:

CareerSession Room Slot 1 Slot 2 ----> etc.
______________________________________________
Programmer | Room 1| Obama, Barack | Palin, Sarah |
| | Biden, Joe | Biden, Joe |
_________|_______|___________________ ______ _|
Policeman | Room 2| McCain, John | Obama, Barack|
| | Palin, Sarah | McCain, John |
________ _|_______|_____________|______________|

....etc.

Tables:

tblEvent

Event_ID
Event
EventLocation

tblTeacher

Teacher_ID
TeacherFirstName
TeacherLastName

tblTeacherEvent (Junction)

TeacherEvent_ID
Teacher_ID
Event_ID

 

[Fred Boer]

Um... a mistake in the tables. It looks more like this for tblEvent:

tblEvent

Event_ID
Event
EventLocation
EventSlot
EventName

Record 1:

"Programmer1"
"Room1"
1
"Programming"

Record 2:

"Programmer2"
"Room1"
2
"Programming"
....

Having written all of this out... my spidey senses are tingling that I have
a poor structure... hm..

Thanks!