Hallo, I am Max and I am new to this forum. Although I have been reading a lot.
My experience with acces is limited but I am trying to learn.
I have made an Acces Table with 14 columns. It is a database where exams results are stored. The first three columns consist of Name, Date, Subject. Column 4 to 14 are questions where a mark between 1 and 5 is submitted.
I made a form so that other people can easily run a query with their personal criteria. For example users can filter on name, place and a range of data.
Now I have added a Option Box with radio buttons so that users can select a mark from 1 to 5.
I want to make sure the Query now filters all the rows in the table that contain a mark in the colums 4 to 14 that is below the users input.
For example the user selects the radiobutton "3", I want the query to return all the rows that have a mark below 3 in either of the 11 colums.
I can make this work by writing OR <[Forms]![Opvragen]![OptMark] in the SQL for the columns 4 to 14. The problem is now that the filter for date, name and subject doesnt work any more because of the OR statement.
How do I solve this? I hope I have explained the problem well enough and help will be much appreciated.
Greetings Max
My experience with acces is limited but I am trying to learn.
I have made an Acces Table with 14 columns. It is a database where exams results are stored. The first three columns consist of Name, Date, Subject. Column 4 to 14 are questions where a mark between 1 and 5 is submitted.
I made a form so that other people can easily run a query with their personal criteria. For example users can filter on name, place and a range of data.
Now I have added a Option Box with radio buttons so that users can select a mark from 1 to 5.
I want to make sure the Query now filters all the rows in the table that contain a mark in the colums 4 to 14 that is below the users input.
For example the user selects the radiobutton "3", I want the query to return all the rows that have a mark below 3 in either of the 11 colums.
I can make this work by writing OR <[Forms]![Opvragen]![OptMark] in the SQL for the columns 4 to 14. The problem is now that the filter for date, name and subject doesnt work any more because of the OR statement.
How do I solve this? I hope I have explained the problem well enough and help will be much appreciated.
Greetings Max