Search results for query: *

Thanks, that works! Now my only problem is the fact that I need to do this with a lot of tables and I'm also getting inaccurate results on my charts because of duplicate lot no's.

Basically we have a form. All 8 X numbers are entered into 8 different bound text boxes on the form, each Lot has 8 x numbers. There is a calculate button and when the user clicks on it it calculates the Average(of the 8 x numbers, likewise for the other calculations), Standard Deviation, Range...

I don't really follow. All i know is that i need 3 straight lines across the graph (UCL, CL and LCL) my knowledge of access isnt sufficient to follow what your saying. My graph has lot number on the X axis and average on the Y axis. It is a line graph and I want to show the LCL, CL and UCL as...

Could i identify the last entry with the ID column? The last entry's ID number would be the highest number in the column so the query could Update XCL column with XBARCL entry with the highest ID number. How would I do that?

Ok what I think I want basically is something like this query (replacing the contents of the brackets with the right code obviously): UPDATE LAC_BP_13010 SET LAC_BP_13010.XCL = (THE LAST ENTRY FROM THE XBARCL COLUMN)

I have my UCL LCL and CL calculated, they are displayed on my form. When my form calculates the control limits it saves them to each record so when i look up a certain record i can see what the control limits were when that record was entered to the table. What i want (for my graph) is to take...

Sorry Ave should be AVG

This is the layout more or less...The formula are taken from existing excel sheets that I have to convert to access and make a UI. Table1 is ; Lot# X1 X2 X3 X4 X5 X6 X7 X8 Ave Stdev Avg-3 Avg+3 Range CL(x) UCL(x) LCL(x) CL(R) UCL(R) LCL(R) the CL(x) is an average of a column of averages...

Hey never mind managed to fix it myself lol

Private Sub AVG_3SIGM_AfterUpdate() If AVG_3SIGM.Value <= 17.4 Then PASSFAIL1.Value = "Fail" End If End Sub sorry THIS is the code

Private Sub AVG_3SIGM_AfterUpdate() If AVG_3SIGM.Value <= 17.4 Then PASSFAIL1.Text = "Fail" End If End Sub The above only works if i manually enter a value in AVG_SIGM but i want it to work when a macro (that contains formulas im using) sends the value to the text box. When i...

Didnt get to try that until now. I'm using a different formula for the control limits and replaced yours with it. The query doesnt seem to work tho. When i try run it it pops up this message box: At most one record can be returned by this subquery. Here is my code: SELECT Table1.AVG, (SELECT...

Thats great MajP Thanks!

I want to create a chart with control limits displayed. But access reports dont let you do this. So i want to get the latest control limits UCL, CL and LCL and populate a column for each one (each box in the column will be the same, based on the most up to date control limits) then i will create...

Hi... I want to auto-fill in one column in my table with the last value entered in another column in my table. How would I go about doing this? thanks in advance