SQL query

First of all I would like to convey my sorry for troubling you.  I
am attaching a syntax which I want to use in the crystal reports. 
But no syntax error but I am not getting the report as I expect.

Data1.RecordSource = "select * from hargadetail where penewaranno =" & Text1.Text

Hargadetail is my table, penerawaranno is my variable in the table and wants to match with text1 in text box.

Nagarajan R; nramamurthy@hotmail.com

A: convert to string You must add quotes on the Text1.Text because penewaranno is a string values (I think reading your code). If it is not so you must convert the Text1.Text to the proper datavalues thats equals the datavalue of penewaranno Return