search between 2 dates using the date picker

[tweety]

i have a query in place that uses a form with a date picker, the date is stored into a variable in a query which is the used in a report to present the sales





i wanted to search for sales beween 2 dates, using the same method, with the date picker on the form.
i have tested a query using >=09 mar 2013 and <=23 mar 2013, how do i go about using the date picker to get the second date

thanks

[rpeare]

between [StartDate] and [EndDate]

[tweety]

i can put [startdate] and [enddate] in the query but how can i carry on using the form? do i need 2 date pickers?

[rpeare]

Yes, you'd need two text boxes then your query criteria would be

Betwen [Forms]![Formname]![StartDateFieldName] and [Forms]![Formname]![EndDateFieldName]