SQL and date range selection

[cal]

I am trying to select a date between the start date and the end date as the
code below states

SQL = "SELECT * FROM Contact WHERE [Next Appointment Date] > #" & txtStartDate.Text
& _
"# <= #" & txtEndDate.Text & "#;"

However I do not get the results I expect. I am using access 2k and vb6.
What am I doing wrong


thanks
cal

[Chris Huynh]

"cal" <sticks2@earthlink.net> wrote:
>
>I am trying to select a date between the start date and the end date as
the
>code below states
>
>SQL = "SELECT * FROM Contact WHERE [Next Appointment Date] > #" & txtStartDate.Text
>& _
> "# <= #" & txtEndDate.Text & "#;"
>
>However I do not get the results I expect. I am using access 2k and vb6.
>What am I doing wrong
>
>
>thanks
>cal

[Chris Huynh]

Try this:
SQL = "SELECT * FROM Contact WHERE [Next Appointment Date] > #" & txtStartDate.Text
& "# AND [NEXT Appointment Date] <= #" & txtEndDate.Text & "#;"

Chris
"cal" <sticks2@earthlink.net> wrote:
>
>I am trying to select a date between the start date and the end date as
the
>code below states
>
>SQL = "SELECT * FROM Contact WHERE [Next Appointment Date] > #" & txtStartDate.Text
>& _
> "# <= #" & txtEndDate.Text & "#;"
>
>However I do not get the results I expect. I am using access 2k and vb6.
>What am I doing wrong
>
>
>thanks
>cal

[nobrainer]

This is what im using for a vb6 project im working on now, using the datetimepicker , The t1 and t2 is the name givin to datetimepicker.
Hope this might help.

'rs.Open ("SELECT DISTINCT Equipment,`Date`,Employee,Fuel,Gallons,Price,Total,Record from tblFuel2 group by Equipment,`Date`,Employee,Fuel,Gallons,Price,Total,Record having date between #" & t1 & "# and #" & t2 & "#"), conn, adOpenKeyset, adLockOptimistic

[Hack]

Do you have a question?