VB-SQL error Data Type mismatch in criteria

[nhb]

I have a db created in access with a table<br>that has a list of fields. I assign a primary key to field (FieldA) that is a numeric-long data type.<br><br>I try to open the query using this command<br>DataEnvironment.rsTblTest.Open _<br>&quot;Select * from tblTest Where FieldA Between '&quot; + lngFldA + &quot;'&quot;<br><br>where lngFldA = cLng(txtFldA.Text)<br>It gives me the error mentioned above.<br><br>Please help...

 

[Zil]

Are you using the keyword Between alone?<br>A correct syntax might be :<br>SELECT * <br>FROM TblTest<br>WHERE FieldA BETWEEN &quot; + lngFldA + &quot; AND &quot; + AnotherLng + &quot;;<br><br>for example<br><br>ZIL

 

[nhb]

It works! Thanks Zil