Variable to Static

[Joseph]

How can I make a variable list of data to a static list?

Situation:
I have a list of course for rehabilitatice services. Right now it is
static, but say in one year the courses get changed (deleted or added from
the curriculum, not from the list), making a static table is not possible.
But I need to be able to reference only those that have been completed for
each student, say with a check mark.

I guess my question is can this variable list be displayed on/in a form,
that for each student, being narrowed down to the time frame that the student
was enrolled, in a yes/no format?

 

[KARL DEWEY]

Add several fields to your Course table --
CourseID - Autonumber - primary key - used in a junction table -
Student_Course
DateActive - DateTime
DateInAct - DateTime
Mandatory - Yes/No

 

[Larry Daugherty]

You're probably asking the wrong question. Pose your question in
terms of the Access problem that you face or in terms of the Real
World problem that you're trying to solve.

By inference, you are looking for scheduling solutions. Many have
been suggested here before. I suggest that you perform a google
search on the Access newsgroups with terms like [schedule, curriculum,
courses, teacher], etc.

Visit www.mvps.org/access and find "netiquette" which will give you
some good guidance on how to use these newsgroups.

HTH

 

[Joseph]

Ok, I understand. And when I need to show the courses for each student
appropriate to the date of entry and date of exit:

Select CoursesID, StudentID, Mandatory, Completed
From tblCoursesTaken
Where DateActive <= tblStudent.DateofEntry and DateInActive >=
tblStudent.DateofExit

yes??