Error 80040e10 - No Value Given For One Or More Required Parameters In SQL String

I have the error 80040e10-No value given for one or more required parameter inside a SQL string and I know that the problem is some/one of my variables passed, however I cannot found the mistake. See down here my code. I got experience in VBA but no much in ACCESS so the query have some problems.

I got the following parameters used inside of the string (I can see before open the recordset that all of them have valid values);

TotalGj is a number result of a dsumTemp1 is a textMketer is a text

My code is down here

Sub Enterdata()
Dim Mketer As String, MonthBR As String
Dim HECAmount As Currency
Dim RsCustomers As ADODB.Recordset, RsFfeesMonth As ADODB.Recordset
Dim Cnx As ADODB.Connection

[Code] .....