I am a newbie to Access VBA so excuse me for asking what some may deem to be a simple question.
Anyways, I am trying to get a total by summing 4 different fields in my form using VBA.
Here is my code:
but it's concatenating the values instead of adding it.Code:Private Sub Command56_Click() Me.Total = Cost_of_White_Wine.Value + Cost_of_Red_Wine.Value + Cost_of_Rose_Wine.Value + Cost_of_Other_Wine.Value End Sub
Can someone please help me?