For our machines we have multiple validation phases. Each phase needs to be "OK" or "N/A" before we can send the machine of to the customer. I have multiple textboxes where they fill in whether the specific phase is "OK" or "NOK"(not oke) or "N/A".
If everything is "OK" or "N/A" then MouldTotal.value="OK" Else MouldTotal.value="NOK"
I cant get this to work and have not found a way that is applicable for this situation.
Thanks for any help in advance.
If DryCycle_status.Value = "OK" Or "N/A" And Temp_status = "OK" Or "N/A" And _
BackPressure_status.Value = "OK" Or "N/A" And _
Filling_status = "OK" Or "N/A" And Injection_status.Value = "OK" Or "N/A" _
And HoldingPressure_status = "OK" Or "N/A" _
And CoolingTime_status.Value = "OK" Or "N/A" And ClampingForce_status = "OK" Or "N/A" And _
ProcessStability_status.Value = "OK" Or "N/A" And AdditionalTesting_status = "OK" Or "N/A" _
Then MouldTotal.Value = "OK" Else MouldTotal.Value = "NOK"
Aucun commentaire:
Enregistrer un commentaire