MS ACCESS

  • Thread starter Thread starter Tracey
  • Start date Start date
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.
 
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
 
Back
Top