Search results

Okay-I will keep working and let you know what I find-Again - a million thank you's!

I didn't save on the last query. I am now getting an error for: No Value given for one or more required parameters. This might be coming in from the main form. I just wanted to get back to you to see if all this looks right. Thank you so much is I haven't said that a hundred times today...

I didn't think I changed anything on my function, I had copied the function that I sent you. I will go and check again. here is the new query. SELECT [RAW_DATA].[RAW_MATERIAL], [RAW_DATA].[SOURCE_TANK], [RAW_DATA].[MANUFACTURING_EQUIPMENT], Count(*) AS NumberofSamples, fnct_Quartile("(select...

One more issue Your program worked great! I am now putting it into our larger database and am getting an error "Syntax error in the FROM clause. I am assuming this is a sql error but when i debug it highlights my function. The RAW DATA is a query that is created when the user completes a form...

A million thank you's I will start playing with this -a million thank you's!!!!!! I will let you know my reults later today.

I hope this helps First again, thank you for your time. I added some more data and have attached it. What I want to do is in a query group by material, then by source tank, then by destination tank. Within that grouping, find the different quartiles from the differences field. Is that what...

No worries Take as much time as you want. Everything you are doing is appreciated. Thank you.

One more thing I must have been really tired when I wrote the last response-please excuse my spelling errors. I think the query I sent you may not have had the groupings. We group by material, source tank, then dest. tank. I apologize for not having the groupings in the file before. I am still...

Thank you again, I hope at some point I am able to help others like you are helping me. I ahve attached the smaller test database for you to look at. I was getting the error in the query so I removed calling the function. I am looking for the first and third quartile based on the "difference" in...

thank you for helping Here is the sql code: SELECT quartile_info.raw_material, quartile_info.order_num, quartile_info.tank, quartile_info.qty, quartile_info.actual_qty, quartile_info.difference FROM quartile_info; Yes the function is in a module and in the project Yes, the excel objects...

okay-here it goes again I have changed my names from above and followed other suggestions and am getting the error undefined function. I have one table with fields: material order_num tank qty actual_qty difference q1_results When I do my query i group in order of material then order_num...

Thank you for explaining that. I am learning. I just named those real quick to get an idea of what I was doing. I have renamed them and am trying a few things before posting again, so you can get and understanding of what I am trying to do-maybe I will get a better understanding as well. Thank...

So I can change the names I can change the names and will try that. I can't see how that would create problems? Can you explain that? Is it the "name" itself that is the problem? I also am really wondering if the logic to this is correct. Should we query everything we want and then take the...

Here is what I am placing in my query and I keep getting an "undefined function" or I get The microsoft jet engine cannot find table or query named quartile. Q1_result: Quartile("data_table","data",3)

Can you explain that a little bit more? Am I selecting from the original column or the column before I want to run the function? I guess I am unsure of exactly how things are running in a query. If I select the original table is the information from the other fields in the query being ran or...

I am new to all of this, so any help, direction and expertise is appreciated. I have a query that runs and filters all kinds of information. In that query I want to run a function, but am not sure what parameters I should use. I am trying to use the orginal parameters of the function but...

now trying to call in a query Hello, I am placing the following code in the query and am getting the error "Undefined function 'Quartile' in expression. quartile1: Quartile([data_table],[1]) I was trying to place the results in a table field for quartile 1 in quartile1 in the same table...

Just posting did it Thank you. I think just posting did the magic. I have been working on this for two days-and poof after posting-issue resolved. Thanks for offering a place like this where magic happens!!!!

I think I got it now It appeared to be in the way I was calling it. Private Sub Command6_Click() MsgBox Percentile("data_table", "data", 0.5) End Sub

I found this on the internet and figure if I get this working I can get the quartile working. Public Function Percentile(strTbl As String, strFld As String, k As Double) As Double Dim rst As ADODB.Recordset Dim dblData() As Double Dim xl As Object Dim x As Integer Set xl...