How to display record between two dates from table

Problem with SQL getting records between two dates entered by user

[mp3mechanical]

Hi geeks,
i am working on a prject with asp & access database.
project is 99% completed but i have a problem of displaying table data from database for all dates betweeen two dates enterd by user.
i.e. user want to display records from 12 november 2005(11/12/2005) to 27 november 2005(11/27/2005).he picks up date by datetimepicker popup & then submit form.

i have tried loops, trgiggers etc for date in two ways by javascript & SQL but they are not working either.

PlLease Help me i have deadline to finish project very soon.

Thank You.

[coopster]

Are the dates columns in the table defined as a

datetime

data type? If so you can probably use the BETWEEN comparison function. I believe Access handles this correctly, meaning that if one or more of the arguments is a datetime data type column it will perform the comparison function as desired.