How to create this COUNT field?

[TracyYu]

I have the following field: Day_1, Day_2, Day_3, ... Day_10 their value can be: X, Y, or Z

Then I have a field: all_X this field is a count of total number of X's entered in the Day_# fields.

Anyone has an idea how to do that? X-)

Thanks in advance.

p.s.
all_X field is locked, so no data can be entered.

 

[Terpsfan]

I created a command button on the form and an integer to keep track of the count.

Private Sub cmdCount_Click()
    Dim intCount As Integer
    
    intCount = 0
    
    If Day_1 = "X" Then
        intCount = intCount + 1
    End If
    If Day_2 = "X" Then
        intCount = intCount + 1
    End If
    If Day_3 = "X" Then
        intCount = intCount + 1
    End If
    If Day_4 = "X" Then
        intCount = intCount + 1
    End If
   If Day_5 = "X" Then
        intCount = intCount + 1
    End If
    If Day_6 = "X" Then
        intCount = intCount + 1
    End If
    If Day_7 = "X" Then
        intCount = intCount + 1
    End If
    If Day_8 = "X" Then
        intCount = intCount + 1
    End If
    If Day_9 = "X" Then
        intCount = intCount + 1
    End If
    If Day_10 = "X" Then
        intCount = intCount + 1
    End If

    
    txtCount = intCount
End Sub