Type mismatch error

[aman]

Hi Guys

I am trying to use like operator in the following statement but getting type mismatch error.

i = DCount("SendingDept", "maintable", "SendingDept='AACP' _
    and RDateMPU>=#" & Format(Combo1, "mm/dd/yyyy") & "# _
    and RDateMPU<=#" & Format(Combo3, "mm/dd/yyyy") & "# _
    and reason like 'No Frontsheet Attached' & " * " ")

Can anyone please suggest me in this.

Thanks
AMan

 

[wazz]

possibly:

i = DCount("SendingDept", "maintable", "SendingDept='AACP' _
    and RDateMPU>=#" & Format(Combo1, "mm/dd/yyyy") & "# _
    and RDateMPU<=#" & Format(Combo3, "mm/dd/yyyy") & "# _
    and reason like 'No Frontsheet Attached[COLOR=red]*' [/COLOR]")

it sounds like one of the parameters entered is the wrong data type. not sure if that will fix it or if you have to do some conversion like CDate or similar.