Is there a way to have an update query update values in a table based on the user's input?
For example, I have categories of tests and educational assignments indigenous to a course I manage. I would like Access to give me a popup or window to ask me a question?
So it would go something like this? "How many students failed the Science Exam?" The user would then put the manual calculation in since it varies from semester to semester.
In access it looks like this.
Tbl 1530Science
Column ID: Tracking Questions
Column ID: Value