Problems with date range in query

[pbaccess]

Hello, I am trying to create a query where the user can enter a date range and receive a list of records filtered by that date range. The column header is "Date" and the criteria field I have as: Between [Enter Start Date] and [Enter End Date]. This normally works when the user enters 1/1/14 and 1/31/14 as start and end dates for example. however, the table I am linked to with an ODBC connection lists the dates in the following format: 12/26/2013 6:15:11 PM and it will only return records if I enter the full date like 1/1/14 12:00:00 AM and 1/31/14 11:59:00 PM. This is cumbersome for the user and if you type just 1/1/14 and 1/31/14 no records are returned.

Is there any way around typing the full long date? I do not know VB, I only know how to use query design.

Thanks in advance!



pb

[trevor40]

One solution would be to base the input critera on form data,
form name = date_form
2 fields, [from_date] and [to_date] in the properties for both fields you can select the format as you need, then use the build option in the query criteria... between [forms]![date_form]![from_date] and [forms]![date_form]![to_date]
use the wizard to create a command button on the form to run the query, under miscellaneous select run query, pick the query from the list.
then, enter the 2 dates and click the button.