"AND" is entering find mode and typing "2010" into both fields...you found that one already.
"OR" is entering find mode, typing "2010" into the first field, selecting "Add New Request" from the "Requests" dropdown menu, then typing "2010" into the second field, then hitting the find button (or enter key).
It's not obvious, but if you think about it it makes some sense.
Enjoy the day!
Each collumnn will hold grades for different years and at the top we choose 2009 grades or 2010 grades for example to "label" that collumm. So thinking ahead ...
This is not a good arrangement to begin with - it requires adjusting the data structure every year. The grades should be individual records in a related table, with each record holding the StudentID, the year and the grade.
Thank you Ninja!!! It was staring me in the face! All I had to do was click on "New Request" :) to get the "or" function from find!
Hi comment!! thanks for the comment! how could I do that which you are suggesting??? I am not sure how to work with relationships? Would it be hard to implement that?!
Have you ever worked with related tables before?