I have a situation in which the user enters a test score and it is filtered through a bunch of data to get a percentile rank. Now there are three sets of data the raw score, standard age score, and finally the percentage. I need the user to put in the raw score, the grade and the age level based on quarters (e.g. 8-3 eight years three months old etc.)
Now here's the tricky part.
Take the data for the first part, the raw score in columns and the grade level, k-8, is in the rows. How do I make a query that uses the row as a variable with out making bunches of different queries?
How do I get the results of that query, given that there is only one answer, feed back to a text box on the form?
And, since this is only the first of three similar equations that I have to calculate, how do I use the result of that first query as a parameter for the next query?
I, eventually, want all three equations to be calculated on the same form. But help with the above will probably give me enough info to do the rest myself.
Any help would be apprechiated!
Fenrir
Now here's the tricky part.
Take the data for the first part, the raw score in columns and the grade level, k-8, is in the rows. How do I make a query that uses the row as a variable with out making bunches of different queries?
How do I get the results of that query, given that there is only one answer, feed back to a text box on the form?
And, since this is only the first of three similar equations that I have to calculate, how do I use the result of that first query as a parameter for the next query?
I, eventually, want all three equations to be calculated on the same form. But help with the above will probably give me enough info to do the rest myself.
Any help would be apprechiated!
Fenrir
