Search results

Sorry. Here you go.

I think that I understand what you are saying. Maybe the db will make this a little more clear. I have attached it. After changing the code, I am now getting a "Type match" error. I would like to only have the "user friendly name" display in the combobox. I think I am doing something wrong with...

Oh my! As I said I have pieced this together from what I thought was similar. I think I understand what you are saying. Here is the code that I copies from- DoCmd.SetWarnings False If Left(cmbCriteriaNbr, 1) = "1" Then DoCmd.OpenQuery "qmakCalcDataOneCriteria" ElseIf Left(cmbCriteriaNbr...

I changed the code and now it will not return a answer for the either of the queries. :eek: Thanks for the suggestion. This is getting very frustrating!!! I would really love if this would work!!

I have to go to a meeting then I will change the code and let you know. Thank you!

Yes, that is correct. So how do I pass to the 2nd selected query?

It will not perform - ElseIf Left(cmbQuery, 1) = "Onset to Door Interval" Then DoCmd.OpenQuery "aqmakOnsettoDoorInterval" and then this- intMedian = DMedian("calcvalue", "tmakMedianCalcValue") MsgBox ("The median is: " & intMedian) to give me the median of this selected query. When performed is...

I have form with a date range criteria, a combo box with a list of queries to perform and a command button to run the median of a result located in a tablefrom the selected query. I am a true beginner of code so I have pieced this together. But I don't know how to get it to perform three...

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. :confused: I would like the median to be...

I appreciate the offer but I think that I can use the previous code. Have a great day!:)

Gotcha!! So I will just remove that part of the code if I chose to exclude, correct? Thank you so much for your help! :)

Thanks for the resource but I still can't get my crosstab query to work with my form. I have attached the database. I want the form "frmCalTreatmentActions" to to be the parameters used when you run "Query1". I have the parameters in the criteria and in the parameters section but it still...

I noticed that before and was getting ready to ask about it. I retried the other code and it runs without errors. But the median value from the table is $7.00. So the module is not correct. Now I am bummed. :( THanks for all you help!!!

I am using the NorthWind database from Microsoft to play in. I have attached the database with my work inclosed.

I tried to use the parameter [Enter Beginning Date] and [Enter Ending Date] in the parameters but it did not work. I entered "2/1/11" and "2/28/11". It gave me the same table that you posted in your "Capture" picture including Jan, Feb and Mar of 2011. :( I am truly am not trying to be lazy. I...

AWESOME!!! Now any suggestion on running for a certain date range and for specified "TreatmentActions"?

I copied and pasted you SQL into a new query and my results are not the same as seen in your picture. See my attachment. But this is exactly the results that I want!!

I would like each intervention totaled then grouped by month and year. My dream would be to have this and then be able to specify which "TreatmentActions" I would like in the query-similar to the picture that I have attached.

Thank you! That is a great detailed report but I need one that gives me just the totals for each "TreatmentAction". Any other suggestions?

Can you show me a crosstab query using my test database that I posted? Sorry that I am a little slow. :confused: