Search Number Range
I have the following columns in my database StudentName, Grade1, Grade2, Grade3, Grade4, Grade5...all the way to Grade20. Each Grade field contains a number between 0 and 100. I want to do a search for a StudentName and grade range using StartRange and EndRange drop down menus so that I can find any student that has a grade in that specific range. I tried using the multi-column search, but realized that it wouldn't compare individual columns. It is not comparing > and < on just Grade1 (for example), but it compares > on all StartRange fields and < on all EndRange fields, so there simply has to be ANY grade higher than 80 and ANY grade lower than 90 for it to show up.
I am setting now trying to figure out how to setup the search with the following logic: (=StudentName) AND ((>= Grade1 AND <=Grade1) OR (>= Grade2 AND <=Grade2) OR (>= Grade3 AND <=Grade3, etc..)). Does that make sense? Is this possible with Datassist?