Sorry my poor English, but i dont understand.
Your first mesasage, you said..
If chkBlue = -1 Then
Blue = 1
Red = 0
End If
What is blue and red? How do you set your table fields?
Hi;
Public Function CheckUncheck(Chk1 As Control, CheckVar As Control, UncheckVar As Control)
If Chk1 = -1 Then
CheckVar = 1
UncheckVar = 0
End If
End Function
Hi;
Do I understand correctly I do not know ??
Try it;
Sum(nz([Score 1],0)+nz([Score 3],0))
or maybe u want it??
iif(isnull(score3),score1,score1+score3)
Hi;
If I understood your question correctly, try it;
Select a.board, a.PartNo, a.TimeStamp, a.Description,a.Status
From Your_Table_name AS a
Where exist
(select last(board)
from Your_Table_name
where
board=a.board...