Q: 
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