Median

A

AccessDB

I have a report(rptBuildRpt) that generates a report from a
form(FrmBuildReports). On the report, I have a text box called
txtMedian. I want to get the median of a column (Engine Price Est) in
the report only (over group). Can someone please give me the code for
this?

For an example I have a text box called txtMax and the control sourcce
is
=Max([Engine Price Est]) and this gives me the Max price for the
report that was generated.
What would the control source code be for Median?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate the median value before a specified list 0
How to write code for Median 3
Report Calculation 2
Consolidation Table from Different Excel Tabs with Different Format 1
Mail Merge Directory Conditional Page Break 0
How to get a total of a particular product 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Help in Median of a quartile 4

Top