Search results

Hi I apologize for the delay in replying. I have put together a small example showing the report and it is the sub totals in red that I am trying to sort on using percentage as the basis. Thanks for your comments Regards Jeff

Hi Thanks for the reply. I am calculating percentages in both group and overall totals using =Format(Sum([Correct])/Sum([Questions]),"0.0%") Regards Jeff

Hi I have a problem creating a sort on a report containing students test results. I would like to sort on the students overall percentage correct but cannot find a way to do it. The student sub totals are a calculated field and Access does not seem to allow sorting on an expression. I looked at...

Hi Thanks for your reply. I realised that the problem was of my own making. I had been converting the database to permit multilingual operation and this required that all references in queries that previously were textual needed to be numerical and I missed one that threw up the error. Many...

Hi I have a form that is used to determine whether students have taken a particular test. The same form is used for all tests and uses a query to create the list of students still to take the test. Everything works fine until there are no student names left and then selecting the combo box...

Hi Thanks for the replies which I will try out. In the meantime I have amended my code to provide an alternative. As the test was generated in an array with the final column being the pointer to the field to be hidden, prior to posting the data to the table I moved the 'answer' value to the...

Hi I have a report that contains six fields, with the first being the question number, the next four containing data and the final field containing a number between 1 and 4, this being the criteria to hide one of the four data fields. The report is for administering a test where there are...

Hi Tom Sorry for the delay in replying. First of all you can delete module 1, this was just for me to use to enable events in case of an interrupted macro and does not have anything to do with the answer, I just forgot to delete it. The If Not Intersect code is to tell Excel to only carry out...

Hi Tom One way to achieve this is using the Worksheet Change Event which will trigger when a cell is changed. Attached is a sample using your example and this can be easily adapted for other scenarios. Regards Jeff