MS ACCESS

T

Tracey

Hi. I am a final year computing science student facing
problems. I am trying to create a school timetable, hence
when a student or teacher's id is entered, their timetable
appears. I have thought about exporting to excel but not
ideal. I have also looked at the cross-tab query/report
but unfortunately this appears to only permit ONE value to
be entered eg either room, subject or teacher (as in case
of student query!!). I am familiar with VB also but have
exhausted my brain trying to think of a way of doing this.

Please can anyone help? It would be much appreciated.
Thankyou.
 
C

Cillies

Tracey Not to sure as to what you want, if you are using
access 2000 can you set up a query using all the relevent
fields from the corresponding tables (Make sure your
relationship are correct)
Then set TeacherID as a parameter.

Hope this helps
 
Top