Code:
RCount% = ssMedian.RecordCount
Code:
OffSet = ((RCount + 1) / 2) - 2
brentg
Last Activity: Jan 16 '12, 09:28 PM
Joined: Jan 11 '12
Location:
-
It did not like this partError message: Type-declaration character does not match declared data type. If I take the % off it then says:run time error 6 and pauses here:where the cursor shows offset =0. -
Yes, I have but when I try to use it in a query :
I get "run time error 6 Overflow" and the debug takes me to this section of the codeCode:SELECT math_medianstep2.student_id, mmedian("math_medianstep2","score") AS med FROM math_medianstep2 GROUP BY math_medianstep2.student_id;the cursor shows the value of Rcount% is 0 nd RecordCount is 97729 (the number of records...Code:RCount% = ssMedian.RecordCount
Leave a comment:
-
I am having troubles getting any of the existing median functions I have found to do what I want. I would need the function to work in a query so that I can save out the value and provide a median score for each student_id. I now have the data like this: Up to six types of tests per student. I have removed any null results. Scores range from 1-21. Any suggestions as to which code would work for this?
Student_id Test Score
90012345...Leave a comment:
-
Probably not feasible as the table will be repeatedly updated as we get changes and report throughout the year. If I get the data into the other format I should be able to use some of the median "group by" code I have seen on the web.Leave a comment:
-
Well I guess not hundreds it just seems like it. 106 scores in the original raw score table and a number of demographic fields for each student in aother table. The raw score tables are used in some detailed reports and then these final cummulative scores are used in some other reports.Leave a comment:
-
On second thought, I will try this and just save out the final scores in this one area and then I can always merge them back in with the other info.Leave a comment:
-
I don't have that option at present. This is only 1 piece of a much larger data base from which we report from. Each student has hundreds of scores and there are numerous reports based on the one student one record format.Leave a comment:
-
see Mariostg reply and enter :
in cell C2. It should work. Then just copy the formula down the column.Code:=IF(NETWORKDAYS(A2;B2)=0,"OK",NETWORKDAYS(A2;B2)
Leave a comment:
-
Calculate median for each record of 6 fields in an access query
I am using Access 2007. I am trying to calculate in an access query the median of six test scores for each student. Some students will not have all scores and the value of the field would be null. I have tried a number of vba functions but I have found none that handles the nulls correctly. I enter the following as a calculated field in the query: medianscore:Med ianY([PVR],[PVR],[ALR],[ARR],[FTR],[PPR])
I thought there would be...
No activity results to display
Leave a comment: