Look-up Query?

[ozzy68]

Hello all,
I am attempting to create query results based on fields with multiple values, and populate a report based on the result of the query. The report is a class roster and the fields in question are "CourseID" and "StartDate". The goal is to pull all data from "trainingSchedule" table that corresponds to a particular "CourseID" on a particular "StartDate"... Is this possible?

 

[jdraw]

Sounds like a great idea. What have you done so far? What tables do you have?
Here's a link to a data model for a general Student Roster - it may help you with some ideas.
http://www.databaseanswers.org/data_models/student_rosters/index.htm

 

[ozzy68]

Thanks for the reply. That layout is really simple, it is a single table that lists the course ID, course title, and student/s that are scheduled. There are a number of other related fields as well. I have created a query based on the table, the query works to pull the data that I want, but it is pulling the data for every course ID. I would like to have the ability to choose from the course ID's available on the table from within the query, which should yield results related to that particular course ID only.