I want to use a form to select the date range and query to be ran and then calculate the median of a list of values within the query. I have the form built, the queries built but I can not get the record source right to call up the list of queries. 
I would like the median to be calculated on the click of the OK button. I am a beginner with VBA so what you see is copied from samples. I have attached my sample db.
Thank you!
I would like the median to be calculated on the click of the OK button. I am a beginner with VBA so what you see is copied from samples. I have attached my sample db. Thank you!
