Im making a program that has to find one particular date on a table, but i cant get it to work, i dont know if the syntax is well or what is going on wrong.
I also want to know if after the where clause I can use a comparison
("select * from Ventas where fecha_v =" & Date & " and codigo = " & txtcod.text & "")
sqltext1 = ("select * from Ventas where fecha_v =" & Date)
Set rs = DataEnvironment1.Connection1.Execute(sqltext1)
If rs.RecordCount = 1 Then......