simple sql syntax

[shopwise]

My Asp recordset contains the following SQL code:

Recordset5.Source = Recordset5.Source & " WHERE ManufacturerPartNumber IN (" & Replace(varPartNumber,"|", ", ") & ") AND (Query1.CustomText04="3") "

An error message is generated as follows:
Expected end of statement

Recordset5.Source = Recordset5.Source & " WHERE ManufacturerPartNumber IN (" & Replace(varPartNumber,"|", ", ") & ") AND (Query1.CustomText04="3") "
-----------------------------------------------------------------------------------------------------------------------------------------------^

What is the proper syntax (marks or symbols to be used) for the text: (Query1.CustomText04="3")

Please note that the CustomText04 field is a text field even though it contains a number as the value.

 

[wvdba]

this should work:
Recordset5.source = Recordset5.source & " WHERE ManufacturerPartNumber IN (" &
Replace(varPartNumber,"|", ", ") & ") AND (Query1.CustomText04='3') "

tested it with msgbox - no errors.