Sorry, I failed to mention that the table does contain unique id's from another client table that corresponds each person who has taken the tests. So, each id will have a pre and post. Also, the data entered into the Question fields are intigers. They are scores.
I had thought about...
tblTest
Fields: Type(pre & post), Question 1, Question 2, etc. . .
*pre and post tests are in same table, just designated by "Type" field.
Desired Result
% change in averages between pre and post for each question.
Obviously it is easy to get pre and post into same query/report, but I am...
I thought this should be a fairly simple thing to solve, but have run into a wall.
I have a subreport that give output of pre and post tests. I have the table set up so the end user can select if the test they are entering is a pre or post test and then enter the corresponding data for that...
I am attempting to make a line graph in a report based upon % results by year. To do this, I am assuming that I need to have % results in my query. I have been unable to achieve this. Does anyone know how to do this?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.