A testing company has changed the format in which they send us our results. Before, every student would have ONE row with multiple testing information as the column headers. For example:
StudentId, TestName1, Test1Score, TestName2, TestScore2, etc
Now, we receive the data where students have multiple rows and each row contains a different, but only one test name and one test score. For example:
StudentID TestName1 TestScore1
StudentID TestName2 TestScore2
StudentID TestName3 TestScore3
I want to use an Append query to add the old data to the new. Using an Append query, I can get the names, scores and IDs in just fine, but the issue is the testing name. In the old version, the test names were the column header names. Now, they are part of the student records.
Long story short, can I create an expression during an Append query that will fill a column with the same value (the tesing name), but that value is NOT part of the records of the original table? Somewhat like an Update query.
StudentId, TestName1, Test1Score, TestName2, TestScore2, etc
Now, we receive the data where students have multiple rows and each row contains a different, but only one test name and one test score. For example:
StudentID TestName1 TestScore1
StudentID TestName2 TestScore2
StudentID TestName3 TestScore3
I want to use an Append query to add the old data to the new. Using an Append query, I can get the names, scores and IDs in just fine, but the issue is the testing name. In the old version, the test names were the column header names. Now, they are part of the student records.
Long story short, can I create an expression during an Append query that will fill a column with the same value (the tesing name), but that value is NOT part of the records of the original table? Somewhat like an Update query.