your query should go like
select <fields> from dbo_ticket_responses where <date> between #Start Date# and #End Date#
Hope this helps