1
Visual Basic 6 / Re:Problemas con busqueda por rango en VB6 y access
« en: Noviembre 30, 2022, 03:58:25 am »
Solo elimina la palabra fecha1 despues del AND
"Select * From [Datos]where [fecha1] Between #" & Format(DTPicker1.Value, "mm/dd/yyyy") & "# AND fecha1 #" & Format(DTPicker2.Value, "mm/dd/yyyy") & "#"
"Select * From [Datos]where [fecha1] Between #" & Format(DTPicker1.Value, "mm/dd/yyyy") & "# AND #" & Format(DTPicker2.Value, "mm/dd/yyyy") & "#"
"Select * From [Datos]where [fecha1] Between #" & Format(DTPicker1.Value, "mm/dd/yyyy") & "# AND fecha1 #" & Format(DTPicker2.Value, "mm/dd/yyyy") & "#"
"Select * From [Datos]where [fecha1] Between #" & Format(DTPicker1.Value, "mm/dd/yyyy") & "# AND #" & Format(DTPicker2.Value, "mm/dd/yyyy") & "#"