mismatch error

[abbylee26]

sSQL = "SELECT [Billing Date], [Service Number], [Subscriber User
Name]," & _
" Fund, Account,[Activity Code], Description, [Total Charge]" & _
" FROM 06_Statements" & _
" WHERE [Billing Date] = '" & Request.Form("cmonth") & "'" & _
" AND [Service Number] = '" & Request.Form("cnumb") & "'" & _
" AND [Total Charge] = '" & Request.Form("camount") & "'"
set rs = Connect.Execute(sSQL)

This query does not work...I get the error message:
Error Type:
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.


If I remove the following line, the statement works fine?
" AND [Total Charge] = '" & Request.Form("camount") & "'"


Request.Form("camount") is a number (.34, 1.2, 9, etc)
the "Total Charge" field in the Access DB is a text field.


I assume I'm comparing apples and oranges. What must I do to get this
to work?

 

[Paxton]

sSQL = "SELECT [Billing Date], [Service Number], [Subscriber User
Name]," & _
" Fund, Account,[Activity Code], Description, [Total Charge]" & _
" FROM 06_Statements" & _
" WHERE [Billing Date] = '" & Request.Form("cmonth") & "'" & _
" AND [Service Number] = '" & Request.Form("cnumb") & "'" & _
" AND [Total Charge] = '" & Request.Form("camount") & "'"
set rs = Connect.Execute(sSQL)

This query does not work...I get the error message:
Error Type:
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.


If I remove the following line, the statement works fine?
" AND [Total Charge] = '" & Request.Form("camount") & "'"


Request.Form("camount") is a number (.34, 1.2, 9, etc)
the "Total Charge" field in the Access DB is a text field.


I assume I'm comparing apples and oranges. What must I do to get this
to work?

AND [Total Charge] = '" & cstr(Request.Form("camount")) & "'"

/P.

 

[abbylee26]

Thanks...it worked after I put the sctr() around "[Total Charge]" also.