Query using Date range

[gselliott]

I have set up a query that will be used to export invoice information to a Text file, i need to be able to export the records from a certain date range which the user will input.

I have managed to do this using input boxes from the query but i would really like the user to input the dates into the form instead. I have set up two text boxes on the form and called them m_from and m_to how do i relate the query to these text boxes?

I have came up with the following but it doesnt work, im obviously doing something wrong!

>=[Forms]![frmExport]![m_from] And <=[Forms]![frmExport]![m_to]

Hope you can help

Thanks

 

[Mile-O]

Between DateValue([Forms]![frmExport]![m_from]) And DAteValue([Forms]![frmExport]![m_to])

 

[gselliott]

Thanks for that it worked a treat!!!