I want to make search a student's grade. Each student follows the 10 subjects. I want to make a search of students in certain grades. I made 10 textboxs to input the value I want to search. I put a combobox on left of each textbox to select a value more than or less than. Each textbox is set to 0 as the default value. And each of my combobox already set as a minimum value ("<").
Here's what I want to do:
“SELECT * FROM tbStudents WHERE lesson1 > textbox1.text AND lesson2 < textbox2.text AND lesson3 < textbox3.text ,… AND lesson10 > textbox10.text
My trouble is how do I determine the value of the maximum and minimum values for each search
Sorry for my bad english