Recent content by dave_the_bear

I'll presume no reply means it isn't possible?

Hi everyone, I have searched the internet for hours and still havent found an answer to my problem. I have a PivotChart that is fed information from a table. I want the PivotChart (Its a bar chart) to change the background of a series value under certain conditions. If a bar series value is...

I have the Sample and Fail fields Control Source =SampleCal([Lot Size]) Should I have a specific event to carry out the function? For example, After Update on the Lot Size field?

On the form. I got rid of the module and put it in: Microsoft Access Class Objects Form_Sample Inspection The exact code inside it is: Option Compare Database Public Function SampleCal(Lot As Integer) Select Case Lot Case 2 To 8 Me.Sample = 2 Me.Fail = 1 Case 9 To 15...

I put the function in the form module (I think?) No longer getting the error. The Sample and Fail field now both display: #Size!

The forms code module? I hit alt+F11 and created a module? Changed the code to: Public Function SampleCal(Lot As Integer) Select Case Lot Case 2 To 8 Me.Sample = 2 Me.Fail = 1 Case 9 To 15 Me.Sample = 3 Me.Fail = 1 Case 16 To 25 Me.Sample = 5 Me.Fail = 1...

The user should: Enter the Expected Quantity in one field. Enter the Faults in the other field. The Lot Size field calculates and displays: [Expected Quantity] - [Faults] Based on the Lot Size the Sample and Fail fields should be filled as follows: Function SampleCal(Lot As Integer)...

Perfect. Thanks.

I am trying to get the total in each column but it doesn't seem to be working? The SUM of 004 should be 3808 but it comes up as 82844? The SUM of 008 should be 88 etc.. Then the numbers seem to be adding? As the result in each column is getting bigger and bigger :confused: This is my SQL...