I apologize for the vagueness, Plog this is also on the same database as my queries issue.
The data is of student test results, it is used to track the student over several years and compare progress. these are exported from the internet into an excel document. From this document I then Import it into a table on the database. The exported document contains The students first name, last name, student id number, each individual answer for the question, their score at the end of the test, the score in a percentage and a scaled score.
From this I can create a query that only selects the fields of the students name, their ID number and the score. It will also grab previous years results. e.g Year 10 score, year 9 score, year 8 score.
First Name l Last name l Year 10 Score from table test 10 l Year 9 Score from table test 9 l Year 8 Score from table test 8
James Bond 30 25 28
I want to then put that query into a report so that It can be easily read.
The problem of having each field name already typed into the table is that each test can have varied amount of questions, meaning it has different amount of field names. I also cannot directly import the file as i need to use a static import to select the starting cells.
Therefore, if I deleted the table, then the query that gets the studentname, ID number and score, will be searching for a table that contains that info. If I import a table with that same name and contains those fields then will that work?
Im more than likely making this more complicated than it should be, I appreciate your patience in this.