Good morning all. As usual I have an issue. I have an ACCESS DB to analyze missed questions from tests. I have a table of all the question identifiers for each test
The tests, when taken, are scanned and graded by an external application (not Access). The instructor then exports a csv file to my drop box. The file contains the quesions, 1,2,3,4,etc...horizontally and the students 1, 2, 3, 4, etc vertically. The matrix shows a 1 for correct answers and a 0 for incorrect answers. So this is just a list of numbers horizontally and vertically. The name of the file contains the Exam identifier information. I import the file into a table using the file name as the table name.
I then run a query on that table summing all the missed questions. I now need to append the results of the summing query to the correct question identifiers table...but how do I select the correct table automatically. Remembering the importated table name contains the test identifier number I broke out the information with a query.
So, I now have each question summed for misses answers. The question numbers 1, 2, 3, 4, etc are in the correct order where they could be appended to the correct question identifier table. I also know the identification information, from the import table name, of the question dentifier table. How do I write VBA for an append query to the identified question identifer table using my sum table information.
Sounds confusing but because the export from the grading application only contains numbers I have to have some way to relate the number of misses to actual question identifiers. Export: Questions 1 - 2 - 3 - etc. Actual question identifiers look like 824-00 1, 824-10 20, 824-10 21, etc.
Thanks,
The tests, when taken, are scanned and graded by an external application (not Access). The instructor then exports a csv file to my drop box. The file contains the quesions, 1,2,3,4,etc...horizontally and the students 1, 2, 3, 4, etc vertically. The matrix shows a 1 for correct answers and a 0 for incorrect answers. So this is just a list of numbers horizontally and vertically. The name of the file contains the Exam identifier information. I import the file into a table using the file name as the table name.
I then run a query on that table summing all the missed questions. I now need to append the results of the summing query to the correct question identifiers table...but how do I select the correct table automatically. Remembering the importated table name contains the test identifier number I broke out the information with a query.
So, I now have each question summed for misses answers. The question numbers 1, 2, 3, 4, etc are in the correct order where they could be appended to the correct question identifier table. I also know the identification information, from the import table name, of the question dentifier table. How do I write VBA for an append query to the identified question identifer table using my sum table information.
Sounds confusing but because the export from the grading application only contains numbers I have to have some way to relate the number of misses to actual question identifiers. Export: Questions 1 - 2 - 3 - etc. Actual question identifiers look like 824-00 1, 824-10 20, 824-10 21, etc.
Thanks,