The query below is partially working for me and by that I mean if I input dates of 4/1/2008 and 5/1/2008 results are returned but if I use 4/1/2008 and 12/31/2008 no results are returned.
The database has records from 2007 through 2009 so I know records exists. There are gaps in the database data range, ie there isnt a records for each day.
Any thoughts on why this is happening?
Dim strQuery As String = "SELECT Vis_Num FROM Data WHERE MDY >= #" & txtStartdate.Text & "# AND MDY <= #" & txtEnddate.Text & "#"