need help on this; I want to have the textbox4 to have the sum of columns based on their employee Id.
I have this code but kept getting error.
strsql = "SELECT emp_id, COUNT(acdcalls) FROM CMS WHERE emp_id= '" & TextBox1.Text & "'"
Dim cmd As New OleDbCommand(strsql, oledbcon)
Dim reader As OleDbDataReader = cmd.ExecuteReader
TextBox4.Text = reader("acdcalls")
please help I'm a newbie here.:sweat: