I have a database with several data tables. Several have data concerning classes which a individual students have taken, one which has data concerning classes required to be taken for a particular major, one which has data about what classes are being offered a particular semester, and one which contains which prerequisites are required for each course. What I am trying to get to happen is for the user to run a report and be prompted for a student's ID number. Access will then run a query based on the classes that student has taken and compare it to the classes required by his major, giving a report detailing the classes that still need to be taken. Access will then run a query based on that report and the data table which contains the information on classed being offered next semester and generate a report detailing the classes the student needs to take which are being offered next semester. Access then runs a report that takes each of the available classes and tells what prerequisites are required for each of those classes. I have accomplished this by creating the queries manually for one student but I want the process to be automated so all a user has to do is key in the student ID number and be given the final report. Can this be done and if so how?

http://www.access-programmers.co.uk/forums/newreply.php?do=newreply&noquote=1&p=78908#
Big Grin
Supply what you have and I will try to help you.

In the query grid (design view) in the 'criteria' line in the field name for "student id" add (without the quotes)"[Enter Student ID]"
When the query is run there will be a message box that says "Enter Student ID" with a blank area for the entry.

Am i missing something? I don't see a download here. Please correct so I can help. :cool: