REPOST: Median for a Continous Report

Guest · Feb 7, 2006

I have tried codes from the following links:
http://www.mvps.org/access/queries/qry0019.htm

http://support.microsoft.com/defaul...10581&Product=acc#XSLTH3133121123120121120120

However, these codes return the same value for ALL my questions in a
continous report. I am guessing that these codes simply return the median
value of that record set (Not relating to each question). Does anyone have
any idea on how to make it work for a continous report? Thanks in advance.

SA · Feb 7, 2006

What you have to do is to calculate the median on each question with the
results for the question itself seen as a recordset. This is difficult to
do at run time on a report, but rather you have to create queries and run
code against for each question and dump that into a table that is then the
source of your report.
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

"questionnaire database analyst"

REPOST: Median for a Continous Report

Guest

SA